title: VBA Textbox invisible characters
body: <p>When I put text from a spreadsheet into a form textbox the text has an extra character.</p>
  
  <p>I placed the contents of the textbox in a cell alongside the original text from a spreadsheet cell. When I do a <code>LEN()</code> function on both the original text and the textbox text, the textbox text shows 25 and the original text is 24.</p>
  
  <p>My question is why is the text different. I cannot figure out what this extra character is.<br>
  The text is 2 lines separated by a <code>CTL</code> and <code>LF</code>. I have also tried to use the <code>Trim()</code> function as well.</p>
  
  <p>Has anyone figured this out? How can I compare the two texts so they are a match if the form text box adds some invisible character?</p>
  
  <p>Below the first row is the <code>LEN()</code> function for A and B cells.<br>
  The second row is the values from the spreadsheet original cell and the second is the same value but put into a textbox on a form then output back to spreadsheet. </p>
  
  <p><a href="https://i.stack.imgur.com/Rr0n2.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Rr0n2.jpg" alt="enter image description here"></a></p>