Occasional Visitor

Any way to get around this limitation of using TEXTJOIN?

"If the resulting string exceeds 32767 characters (cell limit), TEXTJOIN returns the #VALUE! error?


2 Replies


If you need to return more than 32767 characters, Excel might not be the best application for your problem. It is a spreadsheet program, not intended to generate novels.


I think the 32K characters is a hard limit.  That leaves you needing to hold the data as an array of text cells.