/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 vote289 views1 answer
Replace spaces with underscores vbnet
VBA
0 vote321 views2 answers
Excel vba number format file size
VBA
0 vote278 views1 answer
Excel vba extract year
VBA
-1 vote287 views1 answer
How to correct a number to 2 decimal places in vba
VBA
18 votes432 views3 answers
Excel-vba make integer
VBA
0 vote315 views1 answer
Excel vba Column Name from Column Number
VBA
7 votes327 views1 answer
Excerl vba array to range
VBA
1 vote322 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
22 votes412 views1 answer
Excel vba check if directory exists
VBA
0 vote287 views1 answer
Excel vba address not absolute
VBA