Can't generate a hyperlink from a text field when I try to generate and Excel report

[RebeccaK]

Hello,

I have a text field that contains a field $F{link}. This field generates a location on the local machine, for example: "C:\Users\smith\OneDrive\Desktop". I need this location to be a hyperlink when I generate the report in Excel. I've tried editing the Hyperlink tab but it's not working. I've tried editing the expression but that's not working either. Any ideas?

Thank you in advance,

R

[RebeccaK]

UPDATE: I figured out this issue but I got other issues now. The hyperlink has plus signs instead of spaces in the url. For example, it is: "C:/Users/Desktop/Documents/File+Name+Test.docx" instead of "C:/Users/Desktop/Documents/File Name Test.docx". I'm generating an Excel report and the plus signs are making my link inaccessible.