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):
[TABLE="width: 439"]
<tbody>[TR]
[TD]2000 ARLINGTON OAKS DR S; MOBILE Alabama 36695-8739[/TD]
[/TR]
[TR]
[TD]978 VIRGINIA ST SABETHA Kansas 66534-2431[/TD]
[/TR]
[TR]
[TD]5200 WILSHIRE RD CHESAPEAKE Virginia 23321-3280[/TD]
[/TR]
</tbody>[/TABLE]
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):
[TABLE="width: 439"]
<tbody>[TR]
[TD]2000 ARLINGTON OAKS DR S; MOBILE Alabama 36695-8739[/TD]
[/TR]
[TR]
[TD]978 VIRGINIA ST SABETHA Kansas 66534-2431[/TD]
[/TR]
[TR]
[TD]5200 WILSHIRE RD CHESAPEAKE Virginia 23321-3280[/TD]
[/TR]
</tbody>[/TABLE]
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