Split addresses from one cell into multiple cells

Address Assistant in detail

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.

With the Address Assistant for Excel you can:

Split entries Split addresses, city, state, and ZIP code to individual columns Split ZIP+4 codes in one column into two columns Split cell entries if a math is found in a list Extract the first "N" words from cell entries Extract the last "N" words from cell entries

Combine entries Combine addresses into one column (addresses can include or exclude city, state and ZIP code) Combine ZIP+4 codes in two columns into one column

Other features Add leading zeros to ZIP codes Add a leading special space to ZIP codes to preserve leading zeros when exporting to the CSV file Remove special spaces added to ZIP codes Trim leading spaces from cell entries

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.

See also in "Excel - Data management - merge, convert, delete"

• Consolidation Assistant - Consolidate data from Excel workbooks or worksheets.
• CSV File Creator - Create a CSV file from Excel workbooks / worksheets.
• Data Assistant for Excel - Make table form data applicable for Excel pivot tables.
• Data Cleaner for Excel - Remove spaces, Change text case, Replace / modify text, etc.
• Data Extraction Assistant for Excel - Extract data from one worksheet to many spreadsheets.
• Data Loader for Excel - Easy loading, processing, and transferring data .
• Filter Assistant - Filter multiple Excel spreadsheet columns at a time.
• Formula Manager - Manage all formulas in Excel worksheets easily.
• Formula Ref Changer and Sheet Index Creator - Change Excel formula reference types.
• List Assistant - Easy way to re-arrange rows in your Excel worksheet.
• Name Splitter - Split names into several Excel cells.
• Number Manager - Fill in the gaps in Excel workbooks.
• Report To Data Assistant - Convert text reports into Excel worksheet databases.
• Spreadsheet Assistant - Over 200 useful features for MS Excel.
• Text File Importer - Import text files with over a million lines into Excel.
• Text Manager - Change case in Excel, Join text to one cell, Remove spaces, etc..