|
Posted by karen.magno@gmail.com on March 6, 2007, 4:21 pm
Please log in for more thread options > karen.ma...@gmail.com wrote:
> > I am using an import tool to create sales receipts. This tool also
> > creates the customers if they do not already exist in QuickBooks.
>
> > The import file that I am working with has the city, state and zip all
> > in one cell. I need to break these out into three separate cells:
> > cell 1=city, cell 2=state, cell 3=zip.
>
> > I have been experimenting with the convert text to columns with
> > delimiters of spaces and columns. It works fine except in instance
> > where the city or state has two works separate by columns.
>
> > For example New London, CT 12345 get split into 4 cells (when I need
> > only 3 cells)as follows:
> > cell 1: New
> > cell 2: London
> > cell 3: CT
> > cell 4: 12345
>
> > Does anyone know of any other functions in excel that would work for
> > me?
>
> > Thanks!
> > Karen
>
> Karen,
>
> Lots of help available in microsoft.public.excel.worksheet.functions
>
> You'd probably end up working from the zip backwards.... 5 numbers, two
> caps, then the city would remain... but I'm not sure of the function. If
> you'd like to try text to columns again, while in the wizard you can
> double-clik a separator you don't want to keep two word cities
> together... Give it a shot.
>
> Beege- Hide quoted text -
>
> - Show quoted text -
Thank you!
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap