/VBA/Xl vba double quotes in string literal

Xl vba double quotes in string literal

'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

3 votes241 views1 answer
Extract word in a text in excel
VBA
0 vote206 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
3 votes212 views1 answer
Excel vba change format of cell
VBA
0 vote207 views1 answer
Vba sheet visible
VBA
0 vote221 views1 answer
Vba array of integers
VBA
5 votes234 views1 answer
Excel vba first byte from INTEGER
VBA
0 vote201 views1 answer
Vba like with wildcard
VBA
0 vote216 views1 answer
Menus act like radio buttons vb.net
VBA
1 vote234 views1 answer
Perform http request in vb.net
VBA
-1 vote237 views1 answer
How to correct a number to 2 decimal places in vba
VBA