Reverse a name

easybpw · Mar 7th, 2009, 08:29 PM

Hi everyone,

I'm using Excel 2008 for a Mac. Not VBA supported. I would like to reverse a name. In a cell I have a name like this:

Doe, John

I would like it to read:

John Doe

My problem is there are hundreds of names and if I have to change them one by one I will go nuts.

Any suggestions would be appreciated!

Bill

Aladin Akyurek · Mar 7th, 2009, 08:33 PM

In case all entries are like the one you posted...

=TRIM(REPLACE(A2,1,FIND(",",A2),""))&" "&LEFT(A2,FIND(",",A2)-1)

Ron Coderre · Mar 7th, 2009, 09:43 PM

With
A1: (a name in the format: Last, First...eg Newman, Alfred E. )

This formula returns the FirstName(etc) followed by the LastName:

Code:

 
B1: =TRIM(MID(A1&" "&A1,FIND(",",A1)+1,LEN(A1)))

In the above example, the formula returns: Alfred E. Newman

Is that something you can work with?

Mar 7th, 2009, 08:29 PM	#1
easybpw Join Date: Sep 2003 Posts: 315	Reverse a name Hi everyone, I'm using Excel 2008 for a Mac. Not VBA supported. I would like to reverse a name. In a cell I have a name like this: Doe, John I would like it to read: John Doe My problem is there are hundreds of names and if I have to change them one by one I will go nuts. Any suggestions would be appreciated! Bill

Mar 7th, 2009, 08:33 PM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 40,228	Re: Reverse a name In case all entries are like the one you posted... =TRIM(REPLACE(A2,1,FIND(",",A2),""))&" "&LEFT(A2,FIND(",",A2)-1)

Mar 7th, 2009, 09:43 PM	#3
Ron Coderre Join Date: Jan 2009 Location: Massachusetts, USA Posts: 421	Re: Reverse a name With A1: (a name in the format: Last, First...eg Newman, Alfred E. ) This formula returns the FirstName(etc) followed by the LastName: Code: B1: =TRIM(MID(A1&" "&A1,FIND(",",A1)+1,LEN(A1))) In the above example, the formula returns: Alfred E. Newman Is that something you can work with? __________________ Best Regards, Ron Last edited by Ron Coderre; Mar 7th, 2009 at 09:44 PM. Reason: Removed an unnecessary part of the formula

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode