Q:

How to format HYPERLINK in csv-file for Excel import using friendly name

I have a csv-file that looks something like this:
value1;value2;=HYPERLINK("http://somelink";"linkdisplay");value3

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 How to encode a hyperlink in CSV formatted file?, that did not work for me.
Someone got a solution for this?

A:

For file:
String hyperlinks = "\"=HYPERLINK(\"\"file://" + DocumentDataType.strDirectoy + docName + "\"\",\"\""+ DocumentDataType.strDirectoy + docName+ "\"\")\"" + ",";

For website:
String hyperlinks_SourcePath = "\"=HYPERLINK(\"\"http://" +ipAddress+":"+portNumber+"/WorkplaceXT"+ "\"\",\"\""+sourcePathFinal+ "\"\")\"" + ",";

