Home Page link  

Formating city, state and zip

  
Groups | Search | About
User Password
Register Now! Lost Password?

QuickBooks Discussion board - Discussions about the popular financial software by Intuit

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Formating city, state and zip karen.magno@gmail.com 03-06-2007
Posted by karen.magno@gmail.com on March 6, 2007, 3:25 pm
Please log in for more thread options
 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


Posted by vcardx on March 6, 2007, 6:19 pm
Please log in for more thread options
 I suspect you will need a formula/function that puts everything to the left
of the comma in one column. I would suggest that you ask in one of the
microsoft.public.excel newsgroups.

Good luck,
vcardx

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



--
Posted via a free Usenet account from http://www.teranews.com


Similar ThreadsPosted
Formating city, state and zip March 6, 2007, 3:25 pm
Formating city, state and zip March 6, 2007, 3:25 pm
How to pay State Tax for use of material October 9, 2006, 11:39 am
Out-of-state Sales Tax Tracking December 1, 2007, 12:39 pm
Update Billed State after deleting invoice July 27, 2006, 8:04 pm
How do I put a voided invoice's items back to an "uninvoiced" (billable) state? October 18, 2007, 10:56 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap