TEXTJOIN

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?

Thanks

2 Replies

@JMLG_423 

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.

@JMLG_423 

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