Reverse a name

[easybpw]

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]

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

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

 

[Ron Coderre]

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

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

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?