SirGruffles
New Member
- Joined
- Jul 23, 2018
- Messages
- 26
Hello!
I have a massive list of addresses, and I'm looking to pull the state (and the state alone) out of it, and into a separate column.
Here's a few rows as an example (not real addresses, to protect identities):
<tbody>
</tbody>
Not all rows have the 9 digit zip-code, m, but every state is fully spelled out.
Is there a formula I could use to pull out the state?
Thank you for your help!
SirGruffles
I have a massive list of addresses, and I'm looking to pull the state (and the state alone) out of it, and into a separate column.
Here's a few rows as an example (not real addresses, to protect identities):
2000 ARLINGTON OAKS DR S; MOBILE Alabama 36695-8739 |
978 VIRGINIA ST SABETHA Kansas 66534-2431 |
5200 WILSHIRE RD CHESAPEAKE Virginia 23321-3280 |
<tbody>
</tbody>
Not all rows have the 9 digit zip-code, m, but every state is fully spelled out.
Is there a formula I could use to pull out the state?
Thank you for your help!
SirGruffles