Search for multiple words

[kirana2014]

I'm looking for a function that would:

A) Search the data in column A for the words,

Concept
Talking
complex
English
challenged
quiz


If the data in a cell in column A contains any one or two words then return that words on Column B. If 2 value found return both with separated by coma.

[HansDouwe]

Are you still using Ms Off ver 2019? You can check your current version in Excel. Click on your account name at the top and Office user info.

[FlameRetired]

Please try this

Please Login or Register  to view this content.