splitting first names and last name with suffix

M

marj0909

New member
Joined
Dec 28, 2014
Messages
3
Reaction score
0
Points
0
Hi, I was thinking of how to split two to three first names and its last name with suffixes, I've tried many formula using left, right, len, mid excel functions but to no avail. Can anyone help me solve.... please... thanks

CASIANO DOMINGO L. LUCAS, JR. = the result must be LUCAS, JR., CASIANO DOMINGO L.
SHARLENE MARY ROSE M. SANDOVAL = the result must be SANDOVAL, SHARLENE MARY ROSE M.

thanks
 
Hi,
Assume name is in cell A1, try following formula in cell A2
=MID(A1,FIND(".",A1,1)+1,LEN(A1))&", "&LEFT(A1,LEN(A1)-LEN(MID(A1,FIND(".",A1,1)+1,LEN(A1))))

plz find attachment.
 

Attachments

  • test.xlsx
    8.7 KB · Views: 16
sambit said:
Hi,
Assume name is in cell A1, try following formula in cell A2
=MID(A1,FIND(".",A1,1)+1,LEN(A1))&", "&LEFT(A1,LEN(A1)-LEN(MID(A1,FIND(".",A1,1)+1,LEN(A1))))

plz find attachment.
Click to expand...

it worked, and thank you very much
 
You must log in or register to reply here.
Back
Top