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
"Anthony Fagen" wrote in message
...
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.