excel formula how to create strings containing double quotes

The solution for “excel formula how to create strings containing double quotes” can be found here. The following code will assist you in solving the problem.

‘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.”””

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts