| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
A formula for moving a portion of a cell???
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return a portion of data entered into a cell | Excel Discussion (Misc queries) | |||
| how do i find and replace a portion of a cell's formula? | Excel Discussion (Misc queries) | |||
| Formula help ... moving to next cell everyday | Excel Worksheet Functions | |||
| how do i extend the series of a portion of a formula? | Excel Worksheet Functions | |||
| Portion of concatenate formula to have different color and font fo | Excel Worksheet Functions | |||
Threaded Mode
