View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default Following in one cell. Need separate cells DE SOTO, TX, 75115, US

"Mary" wrote in message
...
The following information (DE SOTO, TX, 75115, US) is in one cell in
Excel.
I need to separate the city, state, zip, county into their own cells.

Is there a formula to do this?


The easiest way is from the Data menu/ Text to Columns:
Delimited: by commas
--
David Biddulph