/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 vote177 views1 answer
Convert unix to date vba
VBA
1 vote179 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote175 views1 answer
Excel vba range contains
VBA
1 vote183 views1 answer
Vba login website
VBA
0 vote200 views1 answer
Excel vba move down to next visible cell
VBA
1 vote166 views1 answer
Vba declare api 64 bit 32 bit
VBA
8 votes228 views1 answer
Excel vba make word
VBA
0 vote181 views1 answer
Vba word open document read only
VBA
0 vote183 views1 answer
Vbnet revrese the order of character in string
VBA
1 vote191 views1 answer
Vba format string as cash
VBA