Forum Discussion
not_ashuma
Oct 07, 2023Copper Contributor
Combining Text Cells
Hello, I have a spread sheet that has text in different cells. The cells are sorted by day of the week. I would like to combine all of the text cells into one cell on another sheet based on the d...
HansVogelaar
Oct 07, 2023MVP
You can use TEXTJOIN and FILTER:
=TEXTJOIN(" ". TRUE, FILTER(description_range, day_range="Tuesday", ""))