This is what I needed:

FILTER(array, ISNUMBER(SEARCH(“text“, range)), “No results”)

https://www.ablebits.com/office-addins-blog/2020/06/17/excel-filter-function/#filter-out-blanks