/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 vote154 views1 answer
Excel vba copy range with filter
VBA
0 vote136 views1 answer
Vbnet make a string to unicode converter
VBA
0 vote150 views1 answer
Loop through lines in text file vb net
VBA
0 vote160 views1 answer
Excel vba linter
VBA
0 vote158 views1 answer
Excel vba existence of a file
VBA
0 vote153 views1 answer
Vba border weight
VBA
0 vote156 views1 answer
Loop through each cell in dgv vbnet
VBA
0 vote148 views1 answer
Vb.net round to 2 decimal places
VBA
0 vote165 views2 answers
Vba remove line breaks
VBA
0 vote164 views2 answers
Do until loop vba
VBA