title: VBA Excel String concatenation upper than max length, How to?
body: <p>I need to concat a variable set of strings to create a formul to write in excel.</p>
  <p>The Len(str) function has the correct answer of 383 characters but the real string is truncated at 255 char. How can i concat strings with a length upper to 255 char?</p>
  <p>The example code below.</p>
  <pre><code>Dim tot As String
  tot = &quot;=&quot;
  For i = 0 To UserDefinitedArray.Size
      tot = tot &amp; &quot;'Sheet&quot; &amp; UserDefinitedArray.Item(i).id &amp;&quot;'!&quot; &amp; UserDefinitedArray.Item(i).cell 
      If(i &lt;&gt; UserDefinitedArray.Size -1 ) Then
         tot = tot &amp; &quot;+&quot; 
      End If
  Next i
  
  output_sheet.Range(&quot;A1&quot;).FormulaLocal = tot 
  </code></pre>
  <p>Thanks.</p>