A formula for moving a portion of a cell???

[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

 

[Guest]

With something like:
Princeton NJ 08540

just use Text to Columns with the space as a separator.

 

[Guest]

Have a look at text to columns under the data menu. this will put each part
in a seperate column for you
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

 

[Guest]

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

 

[Guest]

Hi

use the mid function = fx + MID

MID(TEXT,STARTPOS,NUMBER OF LETTERS)
Text is your string = A10

zip code in B10 = mid(Text,StartOfzipCode,NUMBER OF LETTERS)

Hope this helps