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:
The result: Husain
To extract the first name after the comma from A1, use one of the following formula:
The result: Aftab
“Husain, Aftab
To extract the last name before the comma “Husain” from A1, use one of the following formula:
1 | =LEFT(A1,(FIND(",",A1,1)-1)) |
To extract the first name after the comma from A1, use one of the following formula:
1 | =MID(A1,FIND(",",A1)+2,256) |
No comments:
Post a Comment