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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Is there a way to switch name order in an Excel column? (https://www.excelbanter.com/excel-discussion-misc-queries/16686-there-way-switch-name-order-excel-column.html)

makocako

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

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?

Bob Umlas, Excel MVP

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

"makocako" wrote:

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?

All times are GMT +1. The time now is 06:48 PM.