working inside a cell

[Guest]

I have a column that has a list of people last name first, first name. And another column that has the name of the person first name and then last name

Is there a way to transpose the information without having to retype everything? for example

Smith, Tom is there a way to enter a formula and make the cell read: Tom Smith or vice-versa

Please advice

Thank you.

 

[Frank Kabel]

Hi
if you only have Lastname, Firstname try the following
=MID(A1,FIND(",",A1)+2,255) & " " & LEFT(A1,FIND(",",A1)-1)

also have a look at
http://www.cpearson.com/excel/FirstLast.htm

 

[BrianB]

Need to make a new column with a formula like :-
=RIGHT(A1,LEN(A1)-FIND(",",A1,1))&" " &LEFT(A1,FIND(",",A1,1)-1)

Then select the column, and Copy.
Edit/Paste Special/Values.
Delete the original column