Thread: Switch First and Last Names
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
  
Posts: 2,276
Default Switch First and Last Names
Hi,
try

=TRIM(RIGHT(A1,FIND(" ",A1)-1))&" "&TRIM(LEFT(A1,FIND(" ",A1)-1))

"Karen" wrote:

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