Excel: find multiple strings in one cell, and list them in another cell, according to strings in cel-CodePudding

Home > Back-end > Excel: find multiple strings in one cell, and list them in another cell, according to strings in cel

Excel: find multiple strings in one cell, and list them in another cell, according to strings in cel

Time：11-09

Cell A1: product1, product2, product5, dkwex, otherwords

(without sequence)

Cell B1: product1

Cell B2: product2

How to find out strings in Cell A1 according to cell B1 and B2, and list the results in Cell C1?

Cell C1 should be: product1, product2

CodePudding user response：

If you have Excel-365 then give a try on below formula.

=TEXTJOIN(", ",TRUE,FILTER(B1:B10,ISNUMBER(SEARCH(B1:B10,A1))))