Forum Discussion

Copper Contributor

Jul 14, 2022

TEXTJOIN

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

PeterBartholomew1
Silver Contributor
Jul 14, 2022
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.
HansVogelaar
MVP
Jul 14, 2022
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.