Left,Right,Mid,Dollar,Search,Match Function in Excel

 

Left Function

 

=LEFT(A2,FIND(" ",A2))

 

	A	B	C
1	Full Name	First Name
2	Reena Kadam	Reena
3	Vivek Tiwari	Vivek
4	Ayush Chauhan	Ayush
5	Deepti Yadav	Deepti
6	Kunal Gupta	Kunal

 

Right Function

 

=RIGHT(A2,LEN(A2)-FIND(" ",A2))

 

	A	B	C
1	Full Name	Last Name
2	Reena Kadam	Kadam
3	Vivek Tiwari	Tiwai
4	Ayush Chauhan	hauhan
5	Deepti Yadav	Yadav
6	Deepak Kumar	Kumar

 

Mid Function

=MID(A2,4,2)

 

	A	B	C
1	Contact No	Area Code ?
2	44 29 20562311	29
3	45 32 21645866	32
4	45 29 20562311	29
5	46 32 21645866	32

 

Dollar Function

 

=DOLLAR(A2)

 

	A	B	C
1	Indian Rs	Doller Currency
2	120	$120.00
3	140	$140.00
4	150	$150.00
5	160	$160.00

 

Search Function

 

=SEARCH("O",A2)

 

	A	B	C
1	Name	Search Character
2	Madan mohan	8
3
4
5

 

Match Function

 

=MATCH(B4,A2:A6,0)

 

	A	B	C
1	Name
2	Raman
3	Kumar	Name	Position
4	Deepak	Deepak	3
5	Lalit
6	Rahul