/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

3 votes125 views1 answer
Extract word in a text in excel
VBA
0 vote134 views1 answer
Columns dont autoresize on program start vb.net
VBA
1 vote109 views1 answer
How to do error handling in access vba
VBA
0 vote128 views1 answer
Group controls programmatically vb
VBA
1 vote119 views1 answer
Excel vba last column in range
VBA
0 vote124 views1 answer
Search for text in every worksheet excel visual basic
VBA
6 votes121 views1 answer
Excel vba check if a string only contains alpha characters
VBA
1 vote133 views1 answer
Set font for ms chart vb.net
VBA
0 vote131 views1 answer
Vba code for cutoff time
VBA
0 vote123 views2 answers
Do until loop vba
VBA