Rank,Randbetween,Find,Proper,Replace,Substitute Function in Excel

 

Rank Function

 

=RANK(B2,$B$2:$B$8)

 

	A	B	C
1	Name	Percentage	Rank
2	Ram	87%	2
3	Deepak	88%	1
4	Rahul	55%	4
5	Manish	45%	6
6	Laxmi	48%	5
7	Lata	75%	3
8	Suman	35%	7

 

Randbetween Function

 

=RANDBETWEEN(23,74)

 

	A	B	C	D
1	Name	Hindi	Maths	Science
2	Ram	47	62	35
3	Naman	23	31	52
4	Babita	57	52	42
5	Nakuj	24	46	39
6	Mamta	66	53	26
7	Rajeev	45	58	24
8	Raj	62	30	51

Find Function

 

=FIND(A2,B2)

 

	A	B	C
1	Name	Letter	Find
2	Raman Kumar	K	7
3	Ashish Chauhan	C	8
4	Mamta Kumari	r	11
5	Rajkumar yadav	v	14
6	Divya Chauhan	h	8
7	Gungun Saxena	x	10

 

Proper Function

=PROPER(A1)

	A	B	C
	Name	Proper
1	raman	Raman
2	kapil	Kapil
3	teena	Teena
4	rahul	Rahul
5	santosh	Santosh

 

Replace Function

=REPLACE(A2,5,3,B2)

 

	A	B	C
1	ID Part	Replace Text	Replace
2	201-RNO-2356	KPY	201-KPY-2356
3	256-JKS-8658	LDS	256-LDS-8658
4	456-UKL-8678	JKK	456-JKK-8678
5	678-RKM-9639	UTD	678-UTD -9639

 

Substitute Function

 

=SUBSTITUTE(A2,"-"," ",2)

 

	A	B	C
1	ID Part	Replace Text
2	201-RNO-2356	201-RNO 2356
3	256-JKS-8658	256-JKS 8658
4	456-UKL-8678	456-UKL 8678
5	678-RKM-9639	678-RKM 9639