/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 vote371 views1 answer
Xlbycolumns is not declared
VBA
0 vote383 views1 answer
Add text to Shape VBA
VBA
6 votes400 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote348 views1 answer
Vbnet display all axis labels in cahrt
VBA
-1 vote373 views2 answers
Excel vba delete empty rows
VBA
0 vote442 views1 answer
Winforms dark title bar
VBA
0 vote344 views1 answer
Vba dictionary length
VBA
0 vote365 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
0 vote347 views1 answer
Vbnet check if string is only symbols
VBA
0 vote369 views1 answer
Vbnet add axis labels to chart
VBA