Excel extract words before and after a specific word

For example, we have the following text in a cell “A1″ and you’d like to extract the text before the comma (the last name):
Husain, Aftab
To extract the last name before the comma “Husain” from A1, use one of the following formula:
 =LEFT(A1,(FIND(",",A1,1)-1)) 
The result: Husain
To extract the first name after the comma from A1, use one of the following formula:
=MID(A1,FIND(",",A1)+2,256) 
The result: Aftab

No comments:

Post a Comment