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,AB287)
The above combines all into one cell. But values are enclosed within double quotes. How to avoid double quotes?
In general it works as expected, please check attached file.
Can you post a screenshot of the source cells and of the result of the formula. Or, even better, could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
