Assuming you have an
address field named [
Ship To ]
1.) I recommend you create another field Called
Ship to State and make sure it is set to
Formula - Text2.) If you look on your
address field options and scroll all the way down you will see
Address Subfields. Use the field label
[Ship To: State/Region] 3.) so just open up your newly created field
Ship to State and simply enter
[Ship To: State/Region] and you're all set
Now for a report you can simply use the
address field subfields as the columns