/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 vote154 views2 answers
Vba function return array
VBA
0 vote164 views1 answer
Vba character ascii code
VBA
0 vote163 views1 answer
How to get the value of optionbutton in vba
VBA
0 vote156 views1 answer
Hello world vb.net
VBA
1 vote165 views1 answer
Excel vba force recalculation
VBA
0 vote170 views1 answer
Vba copy file
VBA
1 vote169 views1 answer
Add rows to datagridview vb.net
VBA
0 vote157 views1 answer
VB Error Code BC30201
VBA
0 vote157 views1 answer
VB get external IP address
VBA
0 vote161 views1 answer
WGET FTP
VBA