How can I split a name into First(&middle if he/she has) and last name.
I don't want each of first, middle and last names separately.
Results should be as in the sample file.
How can I split a name into First(&middle if he/she has) and last name.
I don't want each of first, middle and last names separately.
Results should be as in the sample file.
Last edited by mehmetics; 03-30-2019 at 08:41 AM.
Please try at
B2
=SUBSTITUTE(A2," "&C2,)
C2
=TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",50)),50))
Thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks