Name conversion

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that is updated by multiple users.
When they enter their names they enter it in the format
(first_name Last_name). Does anyone know how I could
convert this entry to the format (Last_name,first_name)?
I would really appreciate your help.
 
Assuming your first entry is in A1 and your names are always in the format
you described, you can use the following:

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

and fill down to the end of your list.

/i.
 
Back
Top