I have the name: John Smith and I would like a formula that changes it to: Smith, Joh
J jsnyder Sep 4, 2012 #1 I have the name: John Smith and I would like a formula that changes it to: Smith, Joh
C Claus Busch Sep 5, 2012 #2 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 Click to expand... your name in A1, then try: =MID(A1&", "&A1,FIND(" ",A1)+1,LEN(A1)+1) Regards Claus Busch
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 Click to expand... your name in A1, then try: =MID(A1&", "&A1,FIND(" ",A1)+1,LEN(A1)+1) Regards Claus Busch
