Reference all cells with a given string

Question

I do not know if it is possible or not, but it is possible to reference all cells with a certain String in a single cell?

For example, at this point I wanted the cell in column F to be all the values in column B that are in String q*w*. You don’t need to have a visible list of all B strings, but you need to "catch" them all

Answer 1

I believe that whatever you want can be obtained with &

Celula A1-> Hello
Celula A2-> World
Celula A3-> !!!
Celula A4-> =A1&" "&A2&A3