I have a column with comma delimitated data string:

1) abc

2) abc,xyz

3) idf,abc

4) pdq,abc,xyz

5) mabc,xyz

6) idf,abcd

I am trying to show any data set with ID abc in it and i can pick out with a formula the solo abc and ,abc, but I’m having issues with the sets where abc is included within another ID as shown in set 5) & 6). Any suggestions?

​I have a column with comma delimitated data string:1) abc2) abc,xyz3) idf,abc4) pdq,abc,xyz5) mabc,xyz6) idf,abcd I am trying to show any data set with ID abc in it and i can pick out with a formula the solo abc and ,abc, but I’m having issues with the sets where abc is included within another ID as shown in set 5) & 6). Any suggestions?  Read More

​