Tried the formula route, and it works awesome! Thanks. I can use this
elsewhere I bet.
--
I am running on Office 2003, unless otherwise stated.


"JE McGimpsey" wrote:

One way:

A1: First Last
B1: =TRIM(MID(A1,FIND(" ",A1)+1,255) & ", " & LEFT(A1,FIND(" ", A1)-1)

In article ,
Orion Cochrane wrote:

I have an employee list with names (First Last) in one column. Is there a way
to get the last name to show up first and then the first name? TIA.