View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe in CT
 
Posts: n/a
Default separate address data in a cell

Greetings, I have this information in one cell-
777 Anywhere Street
Happy Town, CT
The only comma is just after town. I need to separate out into street
addresss, town and state. How do I do this?

Thanks