/VBA/Excel formula how to create strings containing double quotes

Excel formula how to create strings containing double quotes

'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: academy.excelhero.com

Similar codes

0 vote157 views1 answer
Amd64 vs arm64 linux
VBA
0 vote133 views1 answer
Vba vbcrlf chr
VBA
3 votes124 views1 answer
Excel vba get the workbook full file name with path
VBA
0 vote138 views1 answer
Vbnet click on dgv cells
VBA
0 vote116 views1 answer
Excel vba ternary
VBA
1 vote132 views1 answer
Excel vba last row of range
VBA
0 vote119 views1 answer
Vba text to general
VBA
31 votes232 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote113 views1 answer
Excel text to columns line break
VBA
1 vote125 views1 answer
Highlight selected cell in excel vba
VBA