/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 vote239 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
3 votes270 views1 answer
Excel vba make long from two shorts
VBA
0 vote266 views2 answers
Checking and changing system volume vb.net
VBA
1 vote217 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote196 views1 answer
How to self delete a vbscript file
VBA
0 vote239 views1 answer
Vba verticalalignment
VBA
1 vote246 views1 answer
Extract the second word in a text in excel
VBA
0 vote234 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote246 views1 answer
Vba check if class implements interface
VBA
3 votes256 views1 answer
Excel vba get the workbook full filename with path
VBA