Function for searching a cell for any instances of text and returning a Yes or No

[flute_studio]

I have some data I can't figure out how to recode so I can use it in Pivot tables

The data is formatted as text. I need the formula to search the text in a cell, then return a Yes or No if any of the specific text strings I'm looking for are found. I.e. "classical" or "early."

Here are some examples of the cell contents. The cells I am recoding may have one text string or many o

• I am a professional musician (play for pay)--as a secondary source of income,I teach music to others - as a primary source of income,I play occssionally for others (holiday events or church or parties) but not for pay,I play at home for personal enjoyment.
• Classical, folk, older pop, older country, early,

[dosydos]

If your data starts in A1 then try this:

=IF(OR(IFERROR(SEARCH({"classical","early"},A1),FALSE)),"Yes","No")

[flute_studio]

Thank-you! This worked perfectly.

[dosydos]

Glad it worked and thanks for the rep!