Search for multiple phrases within a cell and extract all those phrases in another column


Assume a simple two column dataset as shown below.  In column A are some text strings.  In each cell are multiple phrases separated by commas.  In column C are some phrases – one in each cell.  The objective is to search for all phrases in each cell and extract the phrases found in another column of the same row.


The expected result is:


I have solved this problem using Power Query a.k.a. Data > Get & Transform in Excel 2016.  You may download my solution workbook from here.

Leave a Comment

Your email address will not be published.