have a look at selecting the columndatatext to columns

--
Don Guillett
SalesAid Software

"wjs2002" wrote in message
...
I have been given a spreadsheet with city, state and zip all in the same
cell. Is there a way to split the city, state and zip into three seperate
cells? I have a large data base and do not want to do each one at a time.