Name conversion

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.
 
I

immanuel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record with longest entry 1
Insert row, table to table - where append goes to correct record 2
INSERT INTO Table, values derived in code from separating a name 1
Excel query help with union select 2
Query for Last Name, First Name works except for one record 4
Excel does not accept text format! 0
Conditional Mail Merge won't suppress blank lines 2
Messages showing in "Find related" but not in Conversation view 0

Top