Hi Mary

Try DataText to columns in the menubar

--
Regards Ron de Bruin
http://www.rondebruin.nl



"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?

--
Thanks,
Mary