Hey all,
I am having some difficulty coming up with an excel formula that splits last name, first name, and middle initials in separate columns. There's variation where the middle initial may be one letter or an entire word and sometimes the character "&" is tossed at the end of column:
CAGLE,DANNY D &
SNEIR,LARRY &
ALONSO,MERRIL M
KIM,JIN SOO &
HARRISON,GEORGE & NANCY
LUKS,BARBARA VACCARO
MILES,JAMIE & MARLON D
LITT,JEFFREY D & LISA J
Is there an excel calculation to get last, first, and middle initial (whether one character or several) in their own columns while getting rid of the "&" unless it's between two first names? So basically the "&" goes away if it's the very last character. Note that if there's two first names, then the "&" would stay and only the initial of righter most name would be split in own column.
Thanks for any response
Bookmarks