If it is just like that with a space separator, try

=MID(A1,FIND(" ",A1)+1,99)&", "&LEFT(A1,FIND(" ",A1))

--
HTH

Bob Phillips

"Will61768" wrote
in message ...

I want to take a list that has in a column Firstname Lastname and what I
want to do is covert that into Lastname, Firstname.

Is that even possible?

The Firstname Lastname are in the same column, I wasn't sure if that
was clear.


Thanks for any suggestions you can offer.


--
Will61768


------------------------------------------------------------------------
Will61768's Profile:
http://www.excelforum.com/member.php...o&userid=27922
View this thread: http://www.excelforum.com/showthread...hreadid=474181