Forum Discussion

JonathanHeuer's avatar
JonathanHeuer
Qrew Cadet
11 years ago

Converting state address field into two letter abbreviation

The state address field displays the full name of the state. I would like to get the two letter abbreviation (i.e. "MI" instead of "Michigan"). Besides creating my own lookup table, is there another ...
Tables and fields
AmberPolston's avatar
AmberPolston
Qrew Cadet
7 years ago
Is there a way to take the formula field & automatically change [Address:  State/Region]?  

The formulas above changed the [Address:  State/Region] to the format I needed, but I have over 10k records where the [Address:  State/Region] fields needs to be changed to the formula field.