title: How to format HYPERLINK in csv-file for Excel import using friendly name
body: <p>I have a csv-file that looks something like this:</p>
  
  <pre><code>value1;value2;=HYPERLINK("http://somelink";"linkdisplay");value3
  </code></pre>
  
  <p>When I import this to Excel 2013, the csv is split on semicolon, also splitting the hyperlink between the link and the friendly text. I have attempted to change List separator on Windows to comma, that actually also changed the requirements for the hyperlink to split the friendly text with a comma, so no luck there. Attempted to add quotes as mentioned in <a href="https://stackoverflow.com/questions/7572268/how-to-encode-a-hyperlink-in-csv-formatted-file">How to encode a hyperlink in CSV formatted file?</a>, that did not work for me.</p>
  
  <p>Someone got a solution for this?</p>