Changing: Last, First to First Last name

  • Thread starter Thread starter Charlie7805
  • Start date Start date
Hi,

With your names in a1 put this in b1 and drag down as reqired
=MID(A1,FIND(" ",A1)+1,999)&" "&LEFT(A1,FIND(" ",A1)-1)

If the comma is genuine and not a typo you can remove it with this mod
=MID(A1,FIND(" ",A1)+1,999)&" "&LEFT(A1,FIND(" ",A1)-2)

Mike
 
One way:

=TRIM(MID(A1,FIND(",",A1)+1,255) & " " & LEFT(A1,FIND(",",A1)-1))
 
The comma is genuine - it's an as400 export. Works great and thanks.
 
You must log in or register to reply here.

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

Extract first and last login time for each day only 6
Pulling only first name 3
LAST, FIRST to First Last 4
Switch Last Name First Name to First Name Last Name 2
First Name & Last Name 2
parsing a full name out into Last, First, Middle 2
Need to separate and rearrange names 11
Switch First and Last Names 3

Back
Top