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

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.


--
zgall1
------------------------------------------------------------------------
zgall1's Profile: http://www.excelforum.com/member.php...o&userid=31652
View this thread: http://www.excelforum.com/showthread...hreadid=513402

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

This is one way

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=513402

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

zgall1 Wrote:
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.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=513402

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

You are correct. That was my mistake.


--
zgall1
------------------------------------------------------------------------
zgall1's Profile: http://www.excelforum.com/member.php...o&userid=31652
View this thread: http://www.excelforum.com/showthread...hreadid=513402