Macro to Tidy address data in Excel
Posted on 2014-10-08
See attached file showing various types of rough data in columns A to E
For each type (one row per type), the output in terms of clean data is in columns G-N.
Currently I am cleaning this data using a series of text-to-columns, Left/right formulas and sorting. I wonder if there is a better way if someone has a clever way of writing a macro to make it faster.
There are anything from 20,000 rows upwards in each set of data.
Assume numbers in this example file could be any number from 1-100
Assume 'Name' could be any name or word - I'm just showing the number of words and spaces for each type.
It doesn't matter if macro isn't 100%, if it does 70% that helps.