Thread: I need to swap last name, first name in a cell to first name last
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default I need to swap last name, first name in a cell to first name last
=RIGHT(A1,LEN(A1)-FIND(",",A1)-1)&" "&LEFT(A1,FIND(",",A1)-1)

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"Wink" wrote in message
...
I need to swap last name, first name in a cell to first name last
Need formula


Reply With QuoteReply With Quote