Thread: Switch First and Last Names
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Switch First and Last Names
=MID(A1&", "&A1,FIND(" ",A1)+1,LEN(A1)+1)


"Karen" wrote:

What is the excel formula to change John Brown to Brown, John? Thanks!
Reply With QuoteReply With Quote