Forum Discussion
Problems with TEXTJOIN it works but when changed one array it give an intermittent value error
Hi! I've been trying textjoin and encounter that when I copy the formula and change the array for text it will give a value error in some cases. I use the following formula and works perfect...
Hi,
I guess it returns #VALUE! for the cells where resulting string exceeds 32767 characters, that is the limit for TEXTJOIN
- Hi Sergei,
Thanks for your time, I try to manually reduce the data an still getting the same error. If you see the table submitted you will that the value error seem to occur in the first part where it has to identify the RBS ID to select the REC ID in CPR_OPEN. You can see this happening in the same column with the exact same formula, for one works perfect, but for other get the value error.I did the simple test
in V6 of Universe is the formula
=TEXTJOIN(CHAR(10),TRUE,CONCATENATE(CPR_OPEN!$A$2:$A$19," ",CPR_OPEN!$BA$2:$BA$19))
which returns an error. If you change 19 on 18 it returns some result.
In column AY of CPR_OPEN you may see the cumulative length of texts in column BA.
For row 18 it's 30319, for the next one - 49191. We have the result for first one and an error for the next one.
Thanks again tor the info, how I might be able to limit the amount of characters it can recover from each option? As you can see in Universe columns N and O Textjoin will bring a lot of info per option, maybe limit it to 5K's per option in case have more than 4 options.
