title: Why excel returns #Value! when in TEXTJOIN function one cell exceeds 252 characters?
body: <p>So i am using TEXTJOIN function in excel and it works great, unless one of the cells which should be joined contains more than 252 characters. </p>
  
  <pre><code>=TEXTJOIN(", ";TRUE;IF($A$1:$A$20=C1;$B$1:$B$20;""))
  </code></pre>
  
  <p>So,for example, if cell B2 has 255 characters, it will give me a #VALUE! error.</p>
  
  <p>If the textjoin is without IF function, it works fine even if cells contain more than 252 characters. Why it is so and is there any solution to this problem?</p>