Hi All—
I am working with data which is obtained from multiple sources, and thus inconsistent in the way addresses are entered. I have formulas based on location criteria and they need to be uniformly formatted. The basic format needs to be as follows:
10 W53 St
565 5 Av
Some users type out "Street" or "Avenue," some use "Ave." or "St.," etc.
I have pieced together a basic macro which handles it fairly well, but it is in 3 parts and I often have to run each step twice in order for it to be thorough. My two main issues are:
1. I would like to be able to combine the 3 parts into 1.
2. Part 3 occasionally gets caught in a loop of some sort and Excel hangs for a while.
3. I would like to be able to run the macro on "selected cells" rather than only on Column A. (The code was copied from a macro I found online and am not sure how to modify it so that it's not limited to the one column.
Following is my code and attached is a spreadsheet with various ways I may receive the data.
Thanks in advance,
Bookmarks