/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 vote237 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
0 vote234 views2 answers
Excel vba copy paste after last row
VBA
0 vote174 views1 answer
How to self delete a vbscript file
VBA
0 vote204 views1 answer
Vb.net round to 2 decimal places
VBA
0 vote306 views1 answer
Vba array of integers
VBA
1 vote229 views1 answer
Vba date to unix timestamp
VBA
0 vote239 views1 answer
Vba horizontalalignment
VBA
0 vote229 views1 answer
Vba compare strings
VBA
22 votes296 views1 answer
Xlvba check for folder
VBA
5 votes264 views1 answer
Excel vba get low byte from INTEGER
VBA