Thread: formula to switch last/first name around?
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
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
Reply With QuoteReply With Quote