Address Assistant

A data related add-in product for Microsoft Excel

Do you have these problems:

• Addresses that need splitting?
• Zip codes without leading zeros?
• Zip codes that need splitting?
• All addresses in one column and need across columns?

The Address Assistant can solve all of these problems and more!

The Address Assistant for Microsoft Excel helps you split cells containing street addresses, cities, states, and zip codes into multiple columns.  It can also recombine such columns (for example just the street addresses) back into a single cell.   Another feature can split zip+4 code entries in a cell into separate cells. The following dialog of the Address Assistant shows the many different features that it has:

One very useful feature of the Address Assistant is the feature that adds leading zeros to zip codes.  This feature is very useful when one imports addresses into an Excel worksheet and Excel converts zip codes like 02305 to 2305 dropping the leading zero!  And if you need to export the zip codes to a CSV file, you may need to add a special space character to prevent leading zeros from being dropped when imported in another program.

Another problem the Address Assistant solves is the need to split addresses from one column into multiple columns.