Hey guys. I have a question which I think should be able to be resolved.
I have this cell range I want to check for text. If cell range A11 to Z15 has text in it, display it underneath eachother on a different part of the page.
For example: Cell G12 contains the text Workshop and cell I15 contains the text Next Week.
I want it to be displayed underneath eachother in a different cell range like this: Workshop Next Week So far I came up with the following solution: =IF(ISNUMBER(SEARCH("",A11:Z15)),A11:Z15,"")
This works almost like I want it to, except it "copies" the cell range and displays it from left to right.
The photo's underneath here are for reference.
Is there any way I can get this to work or is this not possible?
Cheers!