Forum Discussion
Solved
Find text within a comma delimitated string
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...
=OR(TEXTSPLIT(A1,",")="abc")
abc TRUE
abc,xyz TRUE
idf,abc TRUE
pdq,abc,xyz TRUE
mabc,xyz ***FALSE***
idf,abcd ***FALSE***
Xabc,idk FALSE
Idk,xabc FALSE
Corrected to desired results
=OR(TEXTSPLIT(A1,",")="abc")- That covered all of the bases thanks a lot