/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

1 vote336 views1 answer
VBA Loop through recordset
VBA
0 vote408 views1 answer
Winforms dark title bar
VBA
0 vote314 views1 answer
Excel vba disable copy paste
VBA
0 vote336 views1 answer
Vb get ip address
VBA
1 vote321 views1 answer
Vba delete array element
VBA
0 vote339 views1 answer
Vbscript Trim
VBA
0 vote370 views1 answer
Vba count all row
VBA
1 vote298 views1 answer
Ms access open form to new record
VBA
2 votes287 views1 answer
Excel vba pause
VBA
0 vote347 views1 answer
Vba html document reference
VBA