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

mert · Jan 9, 2008

Can anybody help with this? Thanks!

Gary''s Student · Jan 9, 2008

=REPLACE(A1&" "&LEFT(A1,FIND(",",A1)-1),1,FIND(",",A1)+1,"")