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...
RecycleBin_Rob If you prefer a formula, this one seems to work for the two-character quadrants and for the two examples you gave:
=LET(Q,{" NW"," SE"," NE"," SW"},countOfQ,(LEN(A2)-MIN(LEN(SUBSTITUTE(A2,Q,""))))/3,TEXTBEFORE(A2,Q,countOfQ))
Thanks! Unfortunately, I couldn't get it to work. I'll play around with it though. The number of intersections I need to work with are only a handful, so I won't prioritize this portion yet. Thanks!