/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

5 votes200 views1 answer
Excel vba left word from Long Integer
VBA
0 vote238 views1 answer
Visual basic run command
VBA
0 vote187 views1 answer
Dynamic array vba
VBA
1 vote191 views1 answer
Excel vba force recalculation
VBA
0 vote204 views1 answer
How to make a a msgbpx in vbs
VBA
0 vote200 views2 answers
Open url from vba
VBA
0 vote186 views1 answer
Make all controls in an area not visable vb
VBA
0 vote190 views1 answer
Set column width of datagridview vb.net
VBA
-1 vote197 views2 answers
Excel vba delete empty rows
VBA
5 votes131 views1 answer
Vlookup vba
VBA