Change name direction

[mindah26]

How do I change the name John Smith to *Smith, John*

 

[Frank Kabel]

Hi

have a look at
http://www.cpearson.com/excel/FirstLast.htm
Frank

 

[Jason Morin]

One way:

="*"&MID(A1,FIND(" ",A1)+1,255)&", "&LEFT(A1,FIND(" ",A1)-
1)&"*"

HTH
Jason
Atlanta, GA