/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 vote232 views1 answer
Excel vba calculate
VBA
0 vote265 views1 answer
Find database connection string vb
VBA
0 vote257 views2 answers
S yyyy-MM-dd em vb net
VBA
0 vote219 views1 answer
Remove frist letter from string vbnet
VBA
0 vote243 views1 answer
Vba option button selected
VBA
4 votes183 views2 answers
Vba last row
VBA
2 votes225 views1 answer
Excel vba date to string conversion
VBA
1 vote222 views2 answers
Get all column names from excel vba
VBA
0 vote234 views1 answer
Excel vba disable mouse click
VBA
0 vote261 views1 answer
Vba verticalalignment
VBA