How to extract text

Hi, I have a list of cities and states, and I want to extract only first state initials. How can I do that?



Hey @Michael1!

I had a similar use case a long time ago.
Here’s the formula I used back then:

(I added in your field name {City/States})


Now, there is a something important to note.
This (specific) formula only works if you have a comma and a space before the state code.

This requires that you must have consistent and clean data in order for the formula to be consistent.

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.