Hi guys
How do I get extract the second name from the Full name?
Eg: In A1, I have the name as "Basma Hajri" and I want the answer in B1 "Hajri" and so on.
Can someone help me?
Thanks
Toms
Hi guys
How do I get extract the second name from the Full name?
Eg: In A1, I have the name as "Basma Hajri" and I want the answer in B1 "Hajri" and so on.
Can someone help me?
Thanks
Toms
Good afternoon Toms
Put this formula in B1 and copy down as far as you need to:
=RIGHT(A1,(LEN(A1)-FIND(" ",A1,1)))
HTH
DominicB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks