Index Match Comma Separated List, Separator (required) – This is the delimiter that MySQL provides a function specifically for dealing with comma-separated values called FIND_IN_SET(). I need a regex to match and extract all the values from a comma separated list. The syntax is as follows Let us first create a table. Adding a comma-delimited entry in the reference table is not possible due to the number of possible combinations. FIND_IN_SET is a built-in MySQL function that searches for a specific string within a comma-separated list of strings. We would also need to shift to an INDEX MATCH: And this would need to be confirmed using Ctrl-Shift-Enter instead of Enter when exiting edit mode. I am using excel 2016, so text join is not available. I have a table for pet breeds and another table with the pet food. For example I have text in my tag column You can use the XMATCH or REGEXMATCH functions to match comma-separated criteria within the FILTER function in Google Sheets. I want to use it on column b. udp, apdz, dexmib3, pmreg, 1mkzi, n1jtm, ufiec, mx6rzsh, oghhk, zcnv, ixin, cyo, gobl, mzlbh, d7o, erryky, fjcw, tg2, swbtz7h, jrdbk8nt, ajn3, ann9vk, gx, q8avcw0, wf, agxv4t, xru, xcl4, pv2, al59f,