LinkBack URL
About LinkBacks
hello everyone i want to extract the first name from given name which has some unwanted "," or " "(blank space) or both. what i want is just extract first name only from the string for exp...
A B
1 mahek, pina
2 Brian khet
3 loury, whales
Plz help
hello everyone i want to extract the first name from given name which has some unwanted "," or " "(blank space) or both. what i want is just extract first name only from the string for exp...
A B
1 mahek, pina
2 Brian khet
3 loury, whales
Plz help
Welcome to the forum
With names staring in B2, this formula in C2 copy down
=LEFT(B2,MIN(IFERROR(FIND(",",B2),99),IFERROR(FIND(" ",B2),99))-1)
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Thanx kev....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks