ExcelBanter - Formula to change name format

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

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

- - Formula to change name format (https://www.excelbanter.com/excel-discussion-misc-queries/447026-formula-change-name-format.html)

jsnyder

Formula to change name format

I have the name:

John Smith

and I would like a formula that changes it to:

Smith, John

Claus Busch

Formula to change name format

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

All times are GMT +1. The time now is 10:14 AM.