Question : excel formula how to create strings containing double quotes
Answered by : daniel-ferry
'The double quotation mark (") is ASCII character 34, so the
'following Excel formula works:
=CHAR(34) & "Excel rocks." & CHAR(34)
'This formula will display: "Excel rocks."
'Using triple double quotes has the same result:
="""Excel rocks."""Source : http://academy.excelhero.com/ | Last Update : Sat, 04 Apr 20
Question : double quotes in excel concatenate
Answered by : kind-koala-5ttpsikzcliu
=""""&A1&""""Source : https://exceljet.net/formula/double-quotes-inside-a-formula | Last Update : Mon, 08 Mar 21