Forum Discussion
TEXTJOIN
I'm trying to combine(concatenate/textjoin) mutliple cells. Each cell has multiple names separated by \n. =TEXTJOIN(CHAR(10),TRUE,AB24,AB25,AB30,AB32,AB33,AB39,AB41,AB273,AB276,AB280,AB285,AB286,A...
In general it works as expected, please check attached file.