/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 vote252 views1 answer
Vba userform textbox wrap text
VBA
0 vote206 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote240 views1 answer
Vba registry settings
VBA
2 votes219 views1 answer
Excel vba check if string entirely numeric
VBA
2 votes194 views2 answers
Constructor vb.net
VBA
1 vote192 views2 answers
Vba string to date
VBA
0 vote220 views1 answer
Vba array dimensions
VBA
4 votes227 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
0 vote246 views1 answer
Check if cell is dbnullvb.net
VBA
7 votes227 views1 answer
Excerl vba array to range
VBA