Text Search

[richardlima]

Good afternoon

Does anyone know how I do (what formula I use) to search the fields that have a certain fragment of a text?

For example, I need to know which rows in the "Description" field of a table have the "ABC" snippet.

DESCRIPTION TEST
ABCX Yes
ABDF No
AGFA No
AFGD No

If I use the IF formula it does not work because it would only search the field that has only the ABC section. But my goal is to know the lines that have this fragment, but not necessarily be ONLY it.

[ChrisMendoza · Accepted solution]

@richardlima -

This should do the trick for you:

Column =
SWITCH (
    TRUE (),
    FIND (
        "ABC",
        Table1[Description],
        1,
        0
    ) = 1, "YES",
    "NO"
)