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

HTH
--
AP

"Wink" a écrit dans le message de news:
...
I need to swap last name, first name in a cell to first name last
Need formula


Reply With QuoteReply With Quote