Wildcard Search Returning Multiple Values

[th3h0bb5]

Hello all,

I have taken a survey. All my responses are in Column A. I would like to be able to search through those responses and see if they contain a word. If it does, I want to return that cell. So, let's say my search cell (B2) is "bad". I'm looking for a formula to return every comment (cell value) in Column A that contains the word "bad".

I've done a good bit of searching and not found a way to successfully do this. I've attempted Vlookups, Index/Match, and other methods. Many do not function with wildcards, which makes this difficult. Any help would be greatly appreciated!

 

[István Hirsch]

Hello all,

I have taken a survey. All my responses are in Column A. I would like to be able to search through those responses and see if they contain a word..

I thought you needed words from a text and not a substring inside a word, bad in lambada is not a word literally.