/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 vote231 views1 answer
Internet explorer reference vba
VBA
1 vote221 views1 answer
Close form vba
VBA
0 vote260 views1 answer
Create new worksheet excel visual basic
VBA
0 vote230 views1 answer
Vbscript check if string is empty
VBA
0 vote340 views1 answer
Vba line feed
VBA
1 vote218 views1 answer
VBA Loop through recordset
VBA
0 vote212 views1 answer
Change "location" of binding navigator vb
VBA
8 votes249 views1 answer
Run command pormpt in background windows
VBA
1 vote249 views1 answer
Perform http request in vb.net
VBA
5 votes260 views1 answer
Vba low word from Long Integer
VBA