/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 vote131 views1 answer
Vba sheet hide unhide
VBA
0 vote129 views1 answer
Excel named range sum
VBA
0 vote120 views1 answer
Quit excel with save changes dialog vb.net
VBA
0 vote170 views1 answer
Vba userform textbox wrap text
VBA
0 vote137 views1 answer
Excel delete ever other vba
VBA
1 vote141 views1 answer
Sort using vba
VBA
1 vote119 views1 answer
Excel vba saveas force overwrite
VBA
0 vote124 views1 answer
Do until vb.net
VBA
0 vote141 views1 answer
Vba copy file
VBA
1 vote76 views1 answer
Vba Remove Case Sensitivity
VBA