Occasional Visitor

I'm trying to combine(concatenate/textjoin) mutliple cells. Each cell has multiple names separated by \n.



The above combines all into one cell. But values are enclosed within double quotes. How to avoid double quotes?

2 Replies


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?


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