/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 vote323 views1 answer
Excel vba prevent saving workbook
VBA
8 votes376 views1 answer
Excel vba determine number of elements in a 2D array
VBA
5 votes369 views1 answer
Vba low byte from INTEGER
VBA
0 vote316 views1 answer
Vba html document reference
VBA
1 vote348 views1 answer
Vba login website
VBA
1 vote302 views1 answer
Excel date to unix timestamp
VBA
0 vote268 views1 answer
Excel vba linter
VBA
0 vote287 views1 answer
Excel vba open browser
VBA
0 vote299 views2 answers
Excel vba prevent save
VBA
1 vote323 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA