Hello, So if I had flashfill then I wouldn't be asking this question, but I don't have 2013+ so that's out of the question.
I have a location column. Some have city and state, some just have the city. Some have periods at the end and some don't.
eg: Houston, Tx Houston, Tx, Houston, Tx. Houston
Those are examples of how some of the entries are.
I was to extract just the state (if there is a state listed) without the period or anything after the state.
is there a way to do this? or even a way to do flashfill in 2010?
Thanks
Bookmarks