Search code examples
google-sheetshyperlinkconcatenationhrefgoogle-sheets-formula

How to put a href in google sheet cell

I have $92.00 in cell A2 and https://google.com in B2. I want to make a formula so I get following in C2. Can someone please help. I know hyperlink function but I really need exactly same as below in my C2 cell

<a href="https://google.com/">$92.00</a>

Thanks

Solution

  • This should do it:

    =CONCATENATE("<a href=",char(34),B2,"/",char(34),"<",text(A2,"$00.00"),"/a>")

    char(34) is a single quote.