/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 vote174 views1 answer
Supprimer la valeur de celule vba
VBA
0 vote182 views1 answer
How to make a a msgbpx in vbs
VBA
-1 vote179 views1 answer
Vba code to add new column in table
VBA
0 vote177 views1 answer
Convert unix to date vba
VBA
0 vote180 views2 answers
Get excel file from email attachment in vba
VBA
0 vote179 views1 answer
Excel vba select multiple shapes
VBA
0 vote190 views1 answer
Excel vba textbox forecolor disabled
VBA
0 vote182 views1 answer
Excel last used row
VBA
0 vote171 views1 answer
Xlbycolumns is not declared
VBA
0 vote177 views1 answer
Openfiledialog specific folder
VBA