/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

6 votes231 views1 answer
Excel vba check if a string only contains letters
VBA
31 votes515 views1 answer
Vba how to convert a column number into an Excel column
VBA
4 votes229 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
0 vote222 views1 answer
How to extract a file from an ISO:
VBA
25 votes549 views3 answers
String to date vb
VBA
5 votes242 views1 answer
Excel vba get low byte from INTEGER
VBA
1 vote220 views1 answer
Vba date to unix timestamp
VBA
-1 vote240 views1 answer
Vba sendkeys
VBA
5 votes236 views1 answer
Xlvba double quotes in string literal
VBA
0 vote222 views1 answer
Excel vba linter
VBA