- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 21, 2022 04:48 PM
Hey all, this question has been asked in the past but no real solution has been provided. I wonder if 12 months later we might have a work around.
Every time I copy a concatenate cell, it adds quotations marks around the text " ".
Opening each cell individually and then directly copying the text adds such an un-necessary step to my workflow.
Is there another column I could apply a formula to that would remove the quotation marks?
Thanks
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 21, 2022 11:17 PM
That’s interesting. I’ve noticed that quotation marks are added when I copy text that contains new lines (both for text that’s concatenated, as well as text in a Long Text field), but have never noticed quotation marks around concatenated single line text
Where are you copy pasting it to? Lemme see if I can figure out a workaround for you
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 22, 2022 12:00 AM
Thanks Adam, I use it for customer reach out to various different areas (email, sms etc/.).
I’ve tried it into a number of different environments with the same result. Basically if you copy with the cell heighlighted, it’s adds the quotes. If you open/expand the cell and highlight the text, no quotes. This just adds another step though that isn’t optimal for my workflow.
At this stage I’m thinking of setting up a copy macro in keyboard maestro (I’m Mac based) and edit the text with the macro.
Would obviously be much easier just copying as normal.
Thanks again!