/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

1 vote150 views1 answer
Vba login website
VBA
0 vote137 views1 answer
Excel vba address not absolute
VBA
8 votes165 views1 answer
Run command pormpt in background windows
VBA
0 vote207 views1 answer
Excel vba add reference programmatically
VBA
0 vote149 views1 answer
Vbnet revrese the order of character in string
VBA
1 vote132 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote146 views1 answer
Excel vba copy entire sheet paste values
VBA
4 votes145 views1 answer
Excel vba how to reset usedrange
VBA
2 votes138 views1 answer
Date format for ms chart vb.net
VBA
0 vote139 views1 answer
Excel vba scroll to cell
VBA