ExcelBanter - Changing: Last, First to First Last name

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Changing: Last, First to First Last name (https://www.excelbanter.com/excel-worksheet-functions/178030-changing-last-first-first-last-name.html)

Charlie7805

Changing: Last, First to First Last name

Can this be done?

Doe, John to John Doe

Mike H

Changing: Last, First to First Last name

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
"Charlie7805" wrote:

Can this be done?

Doe, John to John Doe

JE McGimpsey

Changing: Last, First to First Last name

One way:

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

In article ,
Charlie7805 wrote:

Can this be done?

Doe, John to John Doe

Charlie7805

Changing: Last, First to First Last name

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

"Mike H" wrote:

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
"Charlie7805" wrote:

Can this be done?

Doe, John to John Doe

All times are GMT +1. The time now is 03:07 PM.