Thread: Swapping two words around in teh one cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Christie Christie is offline
external usenet poster
  
Posts: 25
Default Swapping two words around in teh one cell
I have two words in one cell that I need to swap and place in another cell eg
Allan Smith and would like it to say Smith Allan and then place them in two
seperate cells.
Reply With QuoteReply With Quote