View Single Post
  #9   Report Post  
Old October 21st 15, 06:07 AM posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,872
Default formula to switch last/first name around?

Hi,

Am Tue, 20 Oct 2015 13:02:32 -0700 (PDT) schrieb :

What about if I want to change it from John Brown to Brown, John??


try:
=MID(A1&", "&A1,FIND(" ",A1)+1,LEN(A1)+1)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional