Unwanted quotation marks in pulled through by formula

[Thomas_Lea]

I have a formula that pulls text from another field. That field is a link to another table. Airtable is creating quotation marks around the text if the text contains any punctuation marks. Is there a way of stopping this??

[Elizabeth_Aucti]

Justin_Barrett:

SUBSTITUTE(
    SWITCH(
        {Auction Type},
        "Online", "🎥" & {Auction Type} & " - " & Properties & " - " & Agent,
        "Onsite", "🏡" & {Auction Type} & " - " & Properties & " - " & Agent,
        "In Room Event", "🙋" & {Event Office} & " - " & {Date} & " - " & {Auction Type},
        "Online Event", "📌" & {Event Office} & " - " & {Date} & " - " & {Auction Type}
    ), '"', ""
)

Thank you so much, I knew my formulas need some work :grimacing: :woman_facepalming: Thanks for help, this was perfect

[Mouser-IB-Admin]

I know this is a very old post, but I came digging for help and you were the rockstar that provided it. Just wanted to say thanks for mentioning the substitute formula and showing how it worked because it did exactly that and my problem is fixed now. Have a great day!