/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 vote182 views1 answer
Vbs write file
VBA
0 vote191 views1 answer
Excel VBA web scraping
VBA
0 vote196 views1 answer
Vba dictionary clear
VBA
5 votes202 views2 answers
Excel vba write to the windows registry
VBA
0 vote197 views1 answer
Excel vba first column in range
VBA
0 vote175 views1 answer
Vba loop through textboxes
VBA
0 vote194 views1 answer
Send webhook vbscript
VBA
0 vote182 views1 answer
Vbnet check if string is only numbers
VBA
5 votes174 views1 answer
Excel vba how to unit test vba code
VBA
3 votes184 views1 answer
Excel vba get the workbook full file name with path
VBA