Hi,

Am Tue, 4 Sep 2012 20:35:41 +0000 schrieb jsnyder:

John Smith

and I would like a formula that changes it to:

Smith, John

your name in A1, then try:
=MID(A1&", "&A1,FIND(" ",A1)+1,LEN(A1)+1)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2