How to create strings containing double quotes in Excel formulas ?

How to create strings containing double quotes in Excel formulas ?

Asked on December 14, 2018 in Excel.
Add Comment


  • 3 Answer(s)

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

    = "Maurice ""The Rocket"" Richard"
    
    Answered on December 17, 2018.
    Add Comment

    Try this sollution,

    By preference, can use the CHAR function :

    = "Maurice " & CHAR(34) & "Rocket" & CHAR(34) & " Richard"
    
    Answered on December 17, 2018.
    Add Comment

    Syntax :

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

    Use this example,

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

    = “x” hi

    Answered on December 17, 2018.
    Add Comment


  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.