Forum Discussion
Extract Address from Cell Text
Background: I'm working with address data that uses the quadrant system (ends with NW, NE, SW, or SE). There are only very few instances where it ends with N or S. I have a column of data that...
Perhaps we may simplify to
= REGEXEXTRACT( source[Text], "(?xi) (.*\b( (n|s)?(w|e) | (n|s) )\b) | (.*)" )
I hadn't come across the case-insensitive modifier but then, there is much else that I haven't come across!