/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 vote360 views1 answer
Excel vba set cell value to empty
VBA
0 vote325 views1 answer
Vba verticalalignment
VBA
0 vote343 views1 answer
Send webhook vbscript
VBA
0 vote324 views1 answer
Reset border color textbox vba
VBA
0 vote365 views1 answer
Sort dictionary by key vba
VBA
1 vote345 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
0 vote347 views1 answer
Vba array dimensions
VBA
1 vote342 views1 answer
Vb.net get name by Selection Changed
VBA
3 votes331 views1 answer
Vba request json
VBA
0 vote330 views1 answer
Backspace key has stopped working visual studio
VBA