Editing Data in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I parse address data in Excel to meet USPS requirements for
addresses? I work on spreadsheets with sometimes 1,000s of addresses and want
to write something that will correct (as best as possible) the data so it
meets Postal Service regs for address correctness. I figure it's going to
take a VB program or even a Pivot Table but anyone's help is appreciated.
 
Anthony
Tell us what format your data is in now and what format you want it to
be. Be specific about the layout you have and the layout you want. For
instance, "this" is in the first column, and "that" is in the second column,
and.....etc. HTH Otto
 
You must log in or register to reply here.

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Function or Formula help - get data from another sheet 10
Pivot using 250,000 rows of data in Excel? 1
Excel 2003 - Drop Down List 4
How do I pull certain data out of spreadsheet and import into another? 5
Excel 2007 -- Dates in Pivot Tables in wrong order after refresh 1
Turning Data into a Table 1
Pivot tables after Excel 97 2

Back
Top