/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

7 votes224 views1 answer
Vba array declaration
VBA
0 vote220 views1 answer
Vba declare 64-bit ptrsafe
VBA
0 vote235 views2 answers
Vba remove line breaks
VBA
1 vote222 views1 answer
Excel vba get ordinal number from cardinal number
VBA
1 vote210 views1 answer
VBA Loop through recordset
VBA
0 vote216 views1 answer
Hello world vb.net
VBA
0 vote222 views1 answer
Vba len variant
VBA
0 vote228 views1 answer
Excel vba formatconditions range
VBA
0 vote240 views1 answer
Find if year is leap year vb
VBA
0 vote248 views1 answer
Find database connection string vb
VBA