/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 vote220 views1 answer
Excel vba prevent saving workbook
VBA
0 vote213 views1 answer
Excel run macro every 5 minutes
VBA
0 vote226 views1 answer
Vba random number
VBA
0 vote191 views1 answer
Excel vba populate array with cell values
VBA
0 vote229 views1 answer
Vba character ascii code
VBA
1 vote223 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote205 views1 answer
Vba timestamp -- milliseconds
VBA
4 votes192 views1 answer
Excel vba how to reset usedrange
VBA
0 vote187 views1 answer
Vbnet add new ecel sheet
VBA
0 vote157 views1 answer
How to make a if statement with vbs
VBA