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 | |
28 | |
23 | |
14 | |
14 |