Break up a name

[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

 

[Bob I]

Text to columns, separate on the comma. then text to columns separate on
space.

 

[Vicar]

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)

 

[Jim]

Vicar,

Perfect, thanks for taking the time.

Jim