/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 vote166 views1 answer
Excel vba protect shapes
VBA
1 vote145 views1 answer
Excel vba first and last row and column in range
VBA
0 vote154 views1 answer
Vba copy file
VBA
0 vote161 views1 answer
Tester si une case est vide vba
VBA
0 vote164 views1 answer
Iterate all file in a folder vba
VBA
15 votes191 views1 answer
Excel vba wait
VBA
2 votes135 views1 answer
Excel vba extract file name
VBA
0 vote152 views1 answer
Arq linux
VBA
3 votes161 views1 answer
Extract word in a text in excel
VBA
1 vote140 views1 answer
Close form vba
VBA