Power Query: Identify & Retrieve Partial Strings of Text

It’s one thing to identify if a partial strong of text exists in a cell. It’s another to identify it and also dig it out. That’s the challenge in this video.
1. Identify if an address contains SW, South West, NE or Northeast.
2. If one of those is found, populate what was found in the cell next to the address.

This requires thinking really slowly and planning.
The first step in this video is a cross-join. Along the way, we use a left outer join and the Power Query command: Text.Contains

It’s all here!

For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2