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:
To extract the first name after the comma from A1, use one of the following formula:
“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