Thread: how do I move data to a new line in a cell after a comma?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jeffro Jeffro is offline
external usenet poster
  
Posts: 5
Default how do I move data to a new line in a cell after a comma?
I am trying to move data from one line in a cell to 2 lines in a cell. To
move all the data after a "comma"
Vis:
From
12 Beach St, Palm Beach Qld 4111
To
12 Beach St,
Palm Beach Qld 4111
Can anyone suggest a formula ?
Thanking you in advance
Jeff
Reply With QuoteReply With Quote