View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default Question about Flipping Names in same cell

Hi

This will not work if A1 contains a middlename.

=RIGHT(A1,SEARCH(" ",A1)) & " " & LEFT(A1,SEARCH(" ",A1)-1)

Regards,
Per

"Catherine Damiani" skrev i meddelelsen ...
say i have John Smith in A1 and want it to be Smith John in A2, what would
the formula look like that would be in A2?

thank you!!!