I need to swap last name, first name in a cell to first name last

B

Bob Phillips

=RIGHT(A1,LEN(A1)-FIND(",",A1)-1)&" "&LEFT(A1,FIND(",",A1)-1)

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)
 
B

Bob Phillips

A bit shorter alternative

=MID(A1&" "&A1, FIND(",",A1)+2,LEN(A1)-1)

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)
 

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

First Name & Last Name 2
FIND or LEFT or MID to swap first name with last name? 3
Separate first name, middle name and last name 2
Pulling only first name 3
Windows 10 I would like to know in a batch file how to indentify computer name by using the first 5 of the name and the last 2 of the name then call runcmd 0
Last Name 7
Re-arranging Last, First name???? 1
Flipping a last name comma first name in the same cell 8

Top