Forum Discussion
Mistermonopoly
May 20, 2024Copper Contributor
Re: Find text within a comma delimitated string
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
2 Replies
- Detlef_LewinSilver Contributor
=OR(TEXTSPLIT(A1,",")="abc")- MistermonopolyCopper ContributorThat covered all of the bases thanks a lot