Changing: Last, First to First Last name

[Charlie7805]

Can this be done?

Doe, John to John Doe

 

[Mike H]

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

 

[JE McGimpsey]

One way:

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

 

[Charlie7805]

The comma is genuine - it's an as400 export. Works great and thanks.