How to create strings containing double quotes in Excel formulas ?

Just follow this code to create strings containing double quotes in Excel formulas,

= "Maurice ""The Rocket"" Richard"

Try this sollution,

By preference, can use the CHAR function :

= "Maurice " & CHAR(34) & "Rocket" & CHAR(34) & " Richard"

Syntax :

Three double quotes: ” ” ” x ” ” ” = “x” Excel will auto change to one double quote.

Use this example,

=CONCATENATE("""x"""," hi")

= “x” hi