Hello, I receive address files from clients that are rarely formatted properly and usually have all their data pasted in 1 column. (See example below) I've made a macro that adds "|" at the end of Street, Ave, Road, etc and then splits into different columns but I can't figure out how to split again with things like "Apartment 301" or "Building 3 Box 49".
<colgroup><col></colgroup><tbody>
</tbody>
Any help would be greatly appreciated.
Tatum
| 5927 Howe Street Apartment 301 Pittsburgh PA 15232 |
| 1540 West 50th Ave Denver, Colorado 80221 |
| 1101 West 4th Street Unit 40 Winston Salem, NC 27101 |
| 23 Virginia St. Saint-Isadore, NB E8M B2K CANADA |
| 50 Main St. Building 3 Box 49 Portland, Ore. 97210 |
| 1921 Banbury Road Kalamazoo, MI 49001 |
| 24084 SE 146th Court #33 Beaver PA 15009 |
<colgroup><col></colgroup><tbody>
</tbody>
Any help would be greatly appreciated.
Tatum
