/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 votes190 views1 answer
Excel vba extract file name
VBA
8 votes213 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote209 views1 answer
Create new worksheet excel visual basic
VBA
0 vote197 views1 answer
Vba search string position
VBA
0 vote194 views1 answer
Group controls programmatically vb
VBA
0 vote185 views1 answer
Vba horizontalalignment
VBA
0 vote183 views1 answer
Excel vba hide gridlines
VBA
0 vote190 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote169 views1 answer
Vba len variant
VBA
5 votes189 views1 answer
Excel vba left word from Long Integer
VBA