Sep 23, 2021 07:34 AM
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!
Sep 23, 2021 07:40 AM
dont use ctrl+a to select all. thats what gave me this problem
Sep 23, 2021 07:45 AM
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.
Sep 29, 2021 03:54 PM
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.)