/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 vote183 views1 answer
Vb.net get name by Cell Click
VBA
0 vote155 views1 answer
Excel vba center userform
VBA
4 votes163 views1 answer
Excel vba how to reset usedrange
VBA
1 vote167 views1 answer
Vba login website
VBA
1 vote160 views1 answer
Add control vb
VBA
0 vote164 views1 answer
Excel vba assign shortcut key to button
VBA
5 votes163 views1 answer
Excel vba high word from Long Integer
VBA
0 vote164 views1 answer
Vba string start with
VBA
1 vote173 views1 answer
Vb.net get name by Selection Changed
VBA
0 vote166 views1 answer
Excel vba StartUpPosition
VBA