Substituting Cells In Formula That Contains Equals And Quotes
Solution 1:
You need to use multiple quotes to tell Excel that you want to leave one in the output.
Also you need to use & to concatenate the string together:
="<a href=""" & A1 & """>" & B1 & "</a>"
