Filter function with "text contains"

Suppose, I want to extract the data from this table that contains "J" in their name, irrespective of the place.

We will apply Filter formula along with "ISNUMBER" and "SEARCH" formula.

So, lets imagine that this set of data is in cell A1 to cell C8.


The formula will be:

Considering the above table data started from Cell A1 to Cell C8

=FILTER(A2:C8,ISNUMBER(SEARCH("J",A2:A8)))

Output: