second name first but want to change

[Matkalg]

hi

In cell A1 to A10 my names are in second name first then a space then the first names last but i want thier first names at the front and thier last names in another cell like b1 to b10

can anyone help

Matt

 

[babycody]

Delete column A and your new column B becomes column A.
Copy column A and PasteSpecial as Values.

Correcting MVP. It is early in Alaska still. Since Column A has the references your formula is refering to it might not be wise to delete it just yet. :wink: You want to copy your range from column B then right click over first cell in your list from column B and choose Paste Special> Values over column B. Now you can delete column A if you want to.

 

[Krishnakumar]

=REPLACE(A1,1,LOOKUP(9.999E+307,FIND(" ",A1,ROW($1:$1024))),"")&" "&SUBSTITUTE(A1,REPLACE(A1,1,LOOKUP(9.9999E+307,FIND(" ",A1,ROW($1:$1024))),""),"")

HTH

 

[HalfAce]

Correcting MVP.

Yes, quite right, quite right. (What can I say?)
You'll want to convert column B to values before deleting column A.

Good eye babycody. :wink: