Calc Search for text spread over 2 cells?

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

Thanks upfront!

Jake

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.