Editing Data in Excel

A

Anthony Fagen

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.
 
O

Otto Moehrbach

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
 
Top