Is there a way to switch name order in an Excel column?

M

makocako

I want to be able to switch from first_name last_ name to last_name,
first_name in an excel column without using text to columns then
concatenating the new columns. Is there a formula that will take care of
this more easily?
 
B

Bob Umlas, Excel MVP

=mid(a1,find(" ",a1)+1,255)&", "&left(a1,find(" ",a1)-1)
then fill down
 
Top