Thursday, 17 July 2014

Excel String Functions - LEFT,RIGHT and Mid Functions

LEFT , RIGHT , MID Combo Functions :
Let us Suppose there is a String as below , from that if you want Pull out Substring of Your Desire ,Please look into Below STRING Combo Formulas::

String :
Contact_Us@We@Tamatam.in

LEFT Combo Formula :
From the below String If you want to Retrieve the Substring whatever before “_” , you can Retrieve by using the following formula :

String :
Contact_Us@We@Tamatam.in


Formula :
=LEFT(A2,FIND("_",A2)-1)

Result :
Contact

RIGHT Combo Formula :
From the below String If you want to Retrieve the Substring whatever after second “@” , you can Retrieve by using the following formula :

String :Contact_Us@We@Tamatam.in


Formula :
=RIGHT(A2,LEN(A2)-FIND("@",A2,FIND("@",A2)+1))

Result :
Tamatam.in

MID Combo Formula :
From the below String If you want to Retrieve the Substring whatever in the Middle of “_” and second ‘@” , you can Retrieve by using the following formula :

String :
Contact_Us@We@Tamatam.in

Formula :
=MID(A2,FIND("_",A2)+1,LEN(A2)-(FIND("_",A2)+1+LEN(RIGHT(A2,LEN(A2)-FIND("@",A2,FIND("@",A2)+1)))))

Result :
Us@We







Please come back with you valuable questions on the above Combo Formulas.

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts