Remove Commas & Middle Initial, Flip First and Last Name

**xtinct2** · 06-20-2012, 04:05 PM

I have 2 files with thousands of names and need to manipulate the format of the names so that they match. Is there a formula I can use to make the names in one file formatted like the other? Thank you!

File 1:

Smith,John E
Johnson,Ashley T
Loeb,Steve K

File 2:

John Smith
Ashley Johnson
Steve Loeb

**Ace_XL** · 06-20-2012, 04:16 PM

Good day,

Use below code and drag below assuming your name is in cell A1

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

Press on the star icon if you like this post

**tom1977** · 06-20-2012, 04:41 PM

or If You like VBA like me

You can use this small UDF

Function name(rng)

Dim tb As Variant

tb = Split(Left(rng, Len(rng) - 2), ",")

name = tb(1) & " " & tb(0)

End Function

Remove Commas & Middle Initial, Flip First and Last Name

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Remove Commas & Middle Initial, Flip First and Last Name

Re: Remove Commas & Middle Initial, Flip First and Last Name

Re: Remove Commas & Middle Initial, Flip First and Last Name

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions