Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Quotation marks while copying a formula field

Topic Labels: Formulas
Solved
Jump to Solution
358 5
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi guys,

Recently, I ran into some weird cases while trying to copy-paste a formula field cell values.

When I’m pasting the content, I’m getting the string with quotation marks at the beginning and the ending of the text, while in the field itself I’m not seeing them.

Example:

fuptxt1

You can see there are no quotation marks in the cell itself, but when trying to paste the cell value, I’m getting:

“Text text text”

Any idea on how to avoid these quotation marks?

1 Solution

Accepted Solutions

@Moshe_Peretz If you press Shift-Space on that field, it will open an expanded view of the field contents. Selecting and copying the text from there won’t add the surrounding quotes. It’s a little extra work, but it’s the only workaround that I’m aware of.

See Solution in Thread

5 Replies 5

What is the formula in that field? Where are you pasting the data from that field?

Airtable sometimes does this when the field contains commas or line breaks. The purpose is if you were to paste it into another cell in Airtable, Excel, Sheets, etc. it should paste within a single cell instead of into multiple cells, as commas and line breaks are deliminators.

@Justin_Barrett @Kamille_Parks
Thanks so much for replying!

Well, you are completely right.
This formula field contains a paragraph with line breaks, commas, etc.
We’re usually pasting the content on a web page/email.
Well, I understand the purpose of creating this feature, but is there any workaround to avoid this from happening?

@Moshe_Peretz If you press Shift-Space on that field, it will open an expanded view of the field contents. Selecting and copying the text from there won’t add the surrounding quotes. It’s a little extra work, but it’s the only workaround that I’m aware of.

Thanks, @Justin_Barrett!
It’s not the best solution, but it is something that I can work with.