How to include double quotes in the output of a text formula

I am trying to combine several text elements into an image attribution for each row on my sheet. Here's my formula:

="American Society for Microbiology " + Category1 + ". " + Title1 + ", " + SubmitterFirstName1 + " " + SubmitterLastName1 + IF(ISBLANK([Co-creator #1, Name]1), "", ", " + [Co-creator #1, Name]1) + IF(ISBLANK([Co-creator #2, Name]1), "", ", " + [Co-creator #2, Name]1) + IF(ISBLANK([Co-creator #3, Name]1), "", ", " + [Co-creator #3, Name]1) + IF(ISBLANK([Co-creator #4, Name]1), ".", ", " + [Co-creator #4, Name]1 + ".")

My question is, how do I put the title of the piece (which is in bold in the formula above) in quotes in the final string? In Excel, I would use CHAR(34), but that doesn't seem to exist in Smartsheet. I've even tried adding the double quotes in Excel and then pasting it into Smartsheet, but SS strips out the quotes! So annoying.

Comments

  • L_123
    L_123 ✭✭✭✭✭✭

    " ' ' "

     

    Use a double quote two single quotes and another double quote all smashed together so it looks like this

     

    "''"

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    That's what I would suggest. Changing

    ....+ ". " + Title1 + ", "....

    to

    .... + ". " + "''" + Title1 + "''" + ", "....

    should do the trick.

    thinkspi.com

  • You actually add a backslash before the double quote: ="\"" + Title1 + "\""

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    @klontok

    CHAR and UNICHAR functions are also now available, so you should be able to follow what you said in your original post of using CHAR(34).

    thinkspi.com