A HREF URL in a CONCATENATE() expression

[Kirk_Masden]

Here's a simple tip for anyone who might find themselves in a situation where they want to include a HREF link in a long text column.

Note: This little tip assumes you are familiar with "Rich Text Formatting - in Preview Program."

Postscript: Scroll down to the comment by @Fabian_Weller for an simpler, better way of dealing with the issue.

Here's a shot from an app of mine:

For reasons I'll omit here, the long text containing the link needs to be constructed with a CONCATENATE() expression.  This, however, causes an error if I simply try to put the url in the A HREF tag in quotation marks, as one normally would.  Here's the solution:

In short, four quotation marks produce one quotation mark in this context. This is something I learned from other posts is this community so it's not new at all but I wanted to point out that it works when one needs a quotation mark to construct a A HREF link.

P.S. The quotation marks produced with the four-quotation-mark technique are part of the link expression and so cannot be seen.  The directional quotes you see in the screenshot of my app are displayed using a different technique, explained here:
https://www.googlecloudcommunity.com/gc/Tips-Tricks/Directional-quotes-anywhere-you-want-them/m-p/24...

[Fabian_Weller]

Hi @Kirk_Masden Maybe I don't quite understand, but to use double quotation marks in an expression, you can wrap the whole expression in single quotation marks.
Example:
CONCATENATE('These are " double " quotation marks')

[Kirk_Masden]

No, I think I am the one who didn't understand.  Thank you very much!  I was unaware of this.