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

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

Jim wrote:

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<spacelastname: =MID(A1,FIND(",",A1)+2,FIND(" ",A1,FIND("
",A1)+1)-FIND(",",A1)-1)&LEFT(A1,FIND(",",A1)-1)




"Jim" wrote:

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

Vicar,

Perfect, thanks for taking the time.

Jim



"Vicar" wrote:

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<spacelastname: =MID(A1,FIND(",",A1)+2,FIND(" ",A1,FIND("
",A1)+1)-FIND(",",A1)-1)&LEFT(A1,FIND(",",A1)-1)




"Jim" wrote:

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