Address Assistant
Easily split addresses in one cell into multiple cells. Fix zip codes needing leading zeros.
The following are our data related add-in products for Microsoft Excel.
Easily split addresses in one cell into multiple cells. Fix zip codes needing leading zeros.
Easy compare one or more columns in a list or between lists.
Compare lists in excel and quickly identify the differences.
Consolidate worksheets from multiple workbooks.
Easily copy columns between worksheets based on column titles.
Create CSV files the easy way.
Convert data into a form usable by pivot tables.
Eliminate tedious manual cleaning of data.
Easily combine many rows into a few.
Extract data from one worksheet to multiple worksheets based on row entries.
Make Excel data loading easier.
Quickly find and remove duplicates in one list or between two lists.
Easily filter your data with just a click of a button.
Search lists for matches to key words or phrases.
Match data from one list to another the easy way.
Easily compare up to 10 lists all at the same time.
Merge (concatenate) multiple cells many different ways.
Easily split names into individual cell entries.
Make using pivot tables easier.
Easily and quickly update prices or cost between two lists.
Hide or show rows based on many different search criteria.
Extract rows of data into columns for easy review and printing.
View all the data on a row at one time!
Save and re-use sort settings across worksheets and workbooks.
Import ASCII or text files with over a million lines!
The data add-ins are easily opened from the data add-ins tab:
They can be purchased individually, as part of the Data Collection or the Productivity Suite.