Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Text Search

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 tab...
Need Help
Show and Tell
Tutorial Requests
  • ChrisMendoza's avatar
    ChrisMendoza
    7 years ago

    Anonymous -

     

    This should do the trick for you:

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

     

     

ChrisMendoza's avatar
ChrisMendoza
Resident Rockstar
7 years ago

Anonymous -

 

This should do the trick for you:

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