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