I have a text formula that uses the HYPERLINK function to create a clickable link. Exporting this via a report to an Excel file seemed to work for most data, but not all.

In the Salesforce report itself, all links work. In the exported Excel file, links that contain space characters do not work: they are simply not clickable, just displayed as text.

Example of such a URL:

https://some.domain.com/Path that has a space/img.png

The solution is to convert spaces to %20 before using the HYPERLINK function. So instead of this:

HYPERLINK(Photo_URL_1__c, Photo_URL_1__c)

you should do this:

HYPERLINK(SUBSTITUTE(Photo_URL_1__c, ' ', '%20'), Photo_URL_1__c)

In the Salesforce report, this looks identical, but in the exported Excel file this solves the problem observed in the question.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.