Hello,
I have a bunch of addresses where I need to extract state name to a new cell.
The addresses look the following way:
<colgroup><col></colgroup><tbody>
</tbody>
<colgroup><col></colgroup><tbody>
</tbody>
<colgroup><col></colgroup><tbody>
</tbody>
I have used Rick Rothstein's solution from another thread to extract cities and it works flawlessly even with additions to address like "Administration Bldg 200;".
However, how do I extract state names? The only pattern I see here is that state name always comes after last comma and before the zip code.
Thanks!
I have a bunch of addresses where I need to extract state name to a new cell.
The addresses look the following way:
843 E Main Ste 203, Medford, Oregon 97504-7137 |
<colgroup><col></colgroup><tbody>
</tbody>
7648 Victory Blvd, Newport, Arkansas 72112 |
<colgroup><col></colgroup><tbody>
</tbody>
Administration Bldg 200; 1509 N Boulder Ave, Russellville, Arkansas 72801-2222 |
<colgroup><col></colgroup><tbody>
</tbody>
I have used Rick Rothstein's solution from another thread to extract cities and it works flawlessly even with additions to address like "Administration Bldg 200;".
However, how do I extract state names? The only pattern I see here is that state name always comes after last comma and before the zip code.
Thanks!