Would I have to do that for each of the 9000 customers? If I click on the
column and do it all then it will also do their name and street address, can
you think of a some way I can do it to only the address line?

Thanks
"Gary''s Student" wrote:

With something like:
Princeton NJ 08540

just use Text to Columns with the space as a separator.
--
Gary''s Student
gsnu200707


"McKenna" wrote:

I have a customer list that is not in the format I need to upload to
Quickbooks. I need to have the info in individual columns. Currently, the
city, state and zip are all in one cell and I need to get them into
individual cells. Is there anyway to choose a portion of information in one
cell so that I can get this seperated. I can handle the state portion but
getting the zip code out of that cell would save me alot of time as we have
over 9000 customers. The zip is the only numbers in the cell so isn't there
some kink of IF formula I could use??

Thanks