Referencing all cells with a given string

2

I do not know if it's possible or not, but can you reference all of them in cells with a given String in a single cell?

For example, I wanted the column cell F to be all the values in column B that have String q*w* . You do not need to have a visible list of all Strings of B, but you needed to "catch" them all

    
asked by anonymous 18.05.2018 / 09:42

1 answer

2

I believe that whatever you want can be obtained with &

Celula A1-> Hello
Celula A2-> World
Celula A3-> !!!
Celula A4-> =A1&" "&A2&A3
    
18.05.2018 / 20:48