/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 vote245 views1 answer
Returns an array from function vba
VBA
0 vote245 views1 answer
Ribbon show/hide
VBA
8 votes258 views1 answer
Run command pormpt in background windows
VBA
0 vote284 views1 answer
Vba code for cutoff time
VBA
1 vote230 views1 answer
Vba listindex select multiple items vba
VBA
0 vote252 views1 answer
Tester si une case est vide vba
VBA
0 vote243 views2 answers
Do until loop vba
VBA
0 vote277 views1 answer
Excel vba scroll to cell
VBA
0 vote232 views1 answer
Excel vba chrw max value
VBA
0 vote234 views1 answer
Vba len variant
VBA