/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 vote343 views1 answer
Excel vba add reference programmatically
VBA
3 votes338 views1 answer
Excel vba get the workbook full filename with path
VBA
4 votes324 views1 answer
Excel vba determine number of elements in an array
VBA
0 vote324 views1 answer
Selecttoken em vbnet e json
VBA
2 votes266 views1 answer
Excel vba pause
VBA
3 votes357 views1 answer
Vba continue for each loop
VBA
0 vote325 views1 answer
Search combobox items vb.net
VBA
0 vote316 views1 answer
Vba sort multiple columns
VBA
1 vote319 views1 answer
Vba reverse string
VBA
4 votes300 views1 answer
Excel vba how to reset usedrange
VBA