Break up a name

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Hello,

I ahve a list of names, with middle initials, that I need to break up. For
example the names are formatted like the following:

Bayer, Daniel E.

I need help with three results: the fist is the first name only; the second
is the last name only. And the third, I know I can merge the results for the
first and last name, but if there is a formula that will bring out the first
and last together I would love to learn what that formula is.

Thanks for the help.
Jim
 
Assuming formatting is exactly as shown, & in cell A1:
Firstname: =MID(A1,FIND(",",A1)+2,FIND(" ",A1,FIND(" ",A1)+1)-FIND(",",A1)-2)
Lastname: =LEFT(A1,FIND(",",A1)-1)
Firstname<space>lastname: =MID(A1,FIND(",",A1)+2,FIND(" ",A1,FIND("
",A1)+1)-FIND(",",A1)-1)&LEFT(A1,FIND(",",A1)-1)
 
Back
Top