Changing a list from last name, first name to first name, last name

[zgall1]

I have a list of names in Excel that looks like this
Last name, First name (in one cell)
and I would like to reverse it so that it is
First name, Last name.

Can anyone describe a procedure (possibly using Find/Replace) that will
allow me to do that?

Thanks.

 

[daddylonglegs]

This is one way

=REPLACE(A1&", "&LEFT(A1,FIND(",",A1)-1),1,FIND(",",A1)+1,"")

 

[BenjieLop]

I have a list of names in Excel that looks like this
Last name, First name (in one cell)
and I would like to reverse it so that it is
First name, Last name.

Can anyone describe a procedure (possibly using Find/Replace) that will
allow me to do that?

Thanks.

This is just out of curiosity ... nothing more, nothing less. Why
should the result be "First name, Last name" (with the comma between
the first name and the last name)? Convention in writing a full name
(with the first name being written first) is that there is no comma
between the first and last names.

Regards.

 

[zgall1]

You are correct. That was my mistake