title: How to specify long body in the excel mailto formula in a CSV file?
body: <p>Here is my CSV file:</p>
  
  <pre><code>Email,Values
  "=HYPERLINK(CONCATENATE(""mailto:user@xyz.com?subject=X&amp;body="", SUBSTITUTE(B2,CHAR(10),""%0d%0a"")), ""Send email"")","11231112311123111231
  14562112311123111231
  78292112311123111231
  01233112311123111231
  34543112311123111231
  67834112311123111231
  90154112311123111231
  23465112311123111231
  56765112311123111231
  89066112311123111231
  12376112311123111231
  23487112311123111231"
  </code></pre>
  
  <p>When I open it in Excel I get this:
  <a href="https://i.stack.imgur.com/XrAdk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XrAdk.png" alt="enter image description here"></a></p>
  
  <p>The problem is the length of the text in B2. Exactly the same formula with shorter content in B2 works fine:
  <a href="https://i.stack.imgur.com/lDakX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lDakX.png" alt="enter image description here"></a></p>
  
  <p>Given that I must use a CSV file, does this issue have a solution?</p>