Answers for "excel formula include double quotes in text concatenate"

VBA
5

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."""
Posted by: Guest on March-28-2020
0

double quotes in excel concatenate

=""""&A1&""""
Posted by: Guest on March-01-2021

Code answers related to "excel formula include double quotes in text concatenate"

Code answers related to "VBA"

Browse Popular Code Answers by Language