A formular for moving a portion of a cell

G

Guest

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
 
T

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
==============================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A formula for moving a portion of a cell??? 4
Need VLOOKUP to Work Two Ways 0
Un-Concatenate 3
Need to format varying zip codes... 9
Input distanct from a map into excel 1
Using Excel to Separate info within a Cell 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Cell formular 2

Top