How to create strings containing double quotes in Excel formulas ?
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