I receive a report that is generated by another program. One column contains the address, city, state, and zip (5 and 10 digit) with no coma separators. I was wondering if anyone can think of a macro that would add comas before the Zip, state, and city so that I can use the text to columns tool in excel.
here is an example of the column
7935 COUNCIL PL SUITE 200 MATTHEWS NC 28105
223 WRENWOOD LN CHARLOTTE NC 28211
1125 BIRCH ST APT A ROGERS CITY MI 49779-1406
PO BOX 1376 NEW YORK NY 10018
428 C ST APT 301 SAN DIEGO CA 92101
4682 MISSION BV SAN DIEGO CA 92109
I need it to look like this:
7935 COUNCIL PL SUITE 200 ,MATTHEWS ,NC ,28105
223 WRENWOOD LN ,CHARLOTTE ,NC ,28211
1125 BIRCH ST APT A ,ROGERS CITY ,MI ,49779-1406
PO BOX 1376 ,NEW YORK ,NY ,10018
428 C ST APT 301 ,SAN DIEGO ,CA ,92101
4682 MISSION BV ,SAN DIEGO ,CA ,92109
Then I can run the text to columns and it will split the text into 4 columns.
Thanks in advance for any help that I can receive on this.
Bookmarks