Identify 2 partial strings of data in 1 cell | Text.Contains | Cross Join | Power Query
Someone asked about identifying more than 1 partial string of text in a cell. Hmmm ... interesting.
Well, we go back to our old friends Cross-Join and Text.Combine in Power Query to help us out.
Download the workbook: https://datascopic.net/2Strings
#Text.Combine
#CrossJoin
#PartialText
For a list of my Excel courses at Lynda/LinkedIn:
/ oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.
Website: http://ozdusoleil.com
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...
My old blog: http://datascopic.net/blog-2-2