A formular for moving a portion of a cell

[McKenna]

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

 

[Thomas A. Rowe]

Sound like your are working with Excel, in which case you need to post to the Excel newsgroup.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================