Hi

Try to use Data> Text to Columns in the menu bar

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



<jajoseph@zoominternet.net> wrote in message news:1107674941.810942.162640@c13g2000cwb.googlegroups.com...
> is there a way to Extract city, state and zip code from a single cell
>
> sample data:
>
> 4076 St. Andrews Ct. Canfield, OH 44406
>