/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

2 votes97 views1 answer
Excel vba pause
VBA
0 vote175 views1 answer
Set datetimepicker value to null vb
VBA
0 vote148 views1 answer
Vba listbox remove all items
VBA
0 vote130 views1 answer
Vba check 32 or 64 bit
VBA
1 vote131 views1 answer
Textbox find and replace vb
VBA
0 vote133 views1 answer
Do until vb.net
VBA
0 vote147 views1 answer
Excel run macro every 5 minutes
VBA
0 vote200 views1 answer
Excel vba add reference programmatically
VBA
0 vote154 views2 answers
S yyyy-MM-dd em vb net
VBA
0 vote139 views1 answer
Excel vba disable alerts
VBA