Calc Search for text spread over 2 cells?

In a Calc file I have split texts in 2 columns. How do I specifythe 2 text parts in the search box ?

Thanks upfront!


AFAIK that’s not possible, you need to work with filters.

You may add another column where you merge both columns texts. Then you search in the merged column.