I have a workflow template that sends a PDF and for some reason it’s converting the © symbol to the decimal code ©
I tried wrapping it in TEXT but that didn’t work. Should I be encoding this in something or is this a bug?
Please post a screenshot of the relevant portion of your template.
The workflow template column provides a link to the copyright website or, if blank, it provides a link to the Spotify page with the text of the record label the represents the recording (the ‘P Line’).
if the P Line has a copyright symbol © it comes out like this:
Hmmm… I’d call that a bug, myself: HYPERLINK() should not be encoding the clickable text.
You’ll probably have to work around this, perhaps by using SUBSTITUTE() to replace © with (c)
.
Sounds good. Thanks, Steve.
User | Count |
---|---|
43 | |
25 | |
23 | |
14 | |
13 |