/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 vote208 views1 answer
Create links in msgbox in vb
VBA
0 vote194 views1 answer
Remove first character from string vb
VBA
32 votes278 views2 answers
Excel vba column letter
VBA
0 vote206 views1 answer
Excel vba DisplayAlerts
VBA
0 vote194 views1 answer
Vb.net visible property dgv collumn not working
VBA
0 vote201 views1 answer
Vba change named range address
VBA
3 votes210 views2 answers
Excel "vba" match last value
VBA
0 vote192 views1 answer
Vb streamreader
VBA
0 vote214 views1 answer
Vba static variable
VBA
0 vote199 views1 answer
Vba like with wildcard
VBA