1st name last name to last name, 1st name

[shan]

I have a column that has 1st name and last name. I want to change the column
to be last name, 1st name. Is there a way to do this without having to do
each line of the column individually?

 

[Niek Otten]

Look here:

http://www.cpearson.com/excel/FirstLast.htm

 

[Teethless mama]

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