Unwanted quotation marks when copy-pasting a concatenate formula field outside of Airtable

Hi community,
I wish to copy-paste my field outside of Airtable in programs such as WhatsApp, Notes or Notion… However, the pasted text ends up with unwanted quotation marks at the beginning and at the end whereas in Airtable there are not visible quotations marks.

This is the formula I’m currently using:

CONCATENATE(‘Buenas tardes ‘,{First Name},’\n\n¡Espero que estés muy bien!\nComo te comentaba ayer, (…) manera interna.\n\nEncontrarás adjunto un showcase de algunos proyectos que hemos implementados recientemente con empresas tecnológicas.\n\nMuchas gracias por tu apoyo ‘,{First Name},’ y hasta pronto!\n\nAmaury’)

Thank you!

dont use ctrl+a to select all. thats what gave me this problem

Thanks @Rebecca_Elam, but how do you do instead?
As you can imagine, the purpose of creating this concatenate formula is to save me time and easily move it around copy-pasting.

My guess is that you’re selecting the field and copying directly. If your text contains commas, Airtable automatically wraps the whole thing in quotes just in case you end up pasting it somewhere else in Airtable where the commas might be seen as separators.

Here’s a workaround. Select the field, then press Shift+Space to expand just that field into a larger pop-up. Click and drag to highlight the text in that popup, and it won’t contain any commas when you paste it elsewhere. (I have to do this with a setup that I use regularly. It’s slightly annoying, but it works.)

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.