This question is similar to Table Card export in that it is about exporting to Excel. I am trying to export a dataset / column as a hyperlink. In Excel, that could be a formula: =HYPERLINK(... The issue I'm having is that the export ALWAYS seems to prepend an apostrophe onto the formula, just before the equal sign.
Any ideas on how to get around that? I know that I am not putting it there; my dataflow includes a SQL step that builds the formula: