ExcelBanter - How to change lastname, firstname to firstname lastname in Excel?

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

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

- - How to change lastname, firstname to firstname lastname in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/172299-how-change-lastname-firstname-firstname-lastname-excel.html)

Mert

How to change lastname, firstname to firstname lastname in Excel?

Can anybody help with this? Thanks!

Gary''s Student

How to change lastname, firstname to firstname lastname in Excel?

=REPLACE(A1&" "&LEFT(A1,FIND(",",A1)-1),1,FIND(",",A1)+1,"")
--
Gary''s Student - gsnu200764

"mert" wrote:

Can anybody help with this? Thanks!

All times are GMT +1. The time now is 11:58 PM.