TEXTJOIN

[maddiuk]

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?

[#2]

@maddiuk 

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?

[#3]

@maddiuk 

In general it works as expected, please check attached file.