/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 vote208 views1 answer
Convert number to minutes in vba
VBA
0 vote198 views1 answer
Vba nested dictionary
VBA
1 vote198 views1 answer
Close form vba
VBA
0 vote212 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote203 views1 answer
Remove last 8 characters from string vb
VBA
0 vote238 views1 answer
Set datetimepicker value to null vb
VBA
3 votes208 views1 answer
Vba not equal
VBA
0 vote212 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote211 views1 answer
Excel vba Column Name from Column Number
VBA
0 vote220 views1 answer
Filesystemobject vba reference
VBA