ellsworth2000

asked on

# How can lastname, firstname be changed to firstname, lastname in excel 2010?

Good Day Experts,

So i have a 1200 row list of Doe, John entries and need the list converted to John, Doe in MS Excel 2010. What is the easiest way to do this?

Many Thanks,

Ellsworth

So i have a 1200 row list of Doe, John entries and need the list converted to John, Doe in MS Excel 2010. What is the easiest way to do this?

Many Thanks,

Ellsworth

If the value is in A2 use this formula and copy it down.

=RIGHT(A2,FIND(" ",A2)-1)&" "&LEFT(A2,FIND(",",A2)-1)

=RIGHT(A2,FIND(" ",A2)-1)&" "&LEFT(A2,FIND(",",A2)-1)

If you want to have the comma between the names then use

=RIGHT(A2,FIND(" ",A2)-1)&", "&LEFT(A2,FIND(",",A2)-1)

=RIGHT(A2,FIND(" ",A2)-1)&", "&LEFT(A2,FIND(",",A2)-1)

ASKER

Ok great just simply seperating them in two columns will provide a workaround though what exactly do you mean by copy down? How do i input C2=B2& "," & B1 in to column c? and

ASKER

Ok so i'm a complete noob at excel formulas, What is "Copy Down"?

Also how do i insert that formula?

Also how do i insert that formula?

ASKER CERTIFIED SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

ASKER

Houdini!!!!

You da man!!! That did it. Ok so i have more questions on this but i'll submit another question just so i'm not cascading questions into a single post.

Thanks Everyone!!!

Ells

You da man!!! That did it. Ok so i have more questions on this but i'll submit another question just so i'm not cascading questions into a single post.

Thanks Everyone!!!

Ells

Data>TextToColumns (choose comma delimited)

That will put your names into 2 columns. (I'm assuming Col A and Col B)

Then in Col C put

C2=B2 & "," & B1

Copy down

Copy > Paste Special (values) in Col A

Delete Col B and C.