/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

5 votes602 views1 answer
Vlookup vba
VBA
2 votes222 views1 answer
Date format for ms chart vb.net
VBA
0 vote236 views1 answer
VBA Loop to range
VBA
0 vote239 views1 answer
Excel vba delete folder
VBA
4 votes279 views1 answer
VBA Deep Clone Dictionary
VBA
0 vote250 views1 answer
Excel vba protect sheet
VBA
0 vote230 views1 answer
Compare dates vb
VBA
5 votes182 views1 answer
Vba array worksheet.index
VBA
2 votes231 views2 answers
Vba code to remove duplicates from a column
VBA
2 votes225 views2 answers
Constructor vb.net
VBA