Microsoft Excel 16.78 pasting double quotes

No matter what text editor I paste my content into, a random set of lines

get extra "s added the string I'm trying to copy from Excel.

I turned off auto-complete feature settings in Excel because I am

managing an array of thousands of links with the text content for a

website. I'm using both Seamonkey Source editing and BBEdit for editing

the website. I parsed my links initially with tabs and am bringing them

back together with the concat function into a single column for each

link. The problem is the raw HTML code for some reason when copied out

of Excel has links with two double quotes conjoined! So instead <A

HREF="http://www.microsoft.com/">Microsoft</A> I end up getting <A HREF=""http://www.microsoft.com"">Microsoft</A>.

And sometimes I find links in odd places like before the

<BR><BR> I'm using to separate the lines. Short making a

whole separate sheet with just the concat command and exporting the

whole sheet, is there anything I can do to prevent the output of my copy

paste from Excel from having excess quotes in the clipboard when I copy

a column of text with command-C?

Excel version 16.78 (23100B02) running on Mac OS Sequoia.


Yes I've tried asking on Microsoft Forums, and they are having technical issues at this time.

Posted on Aug 31, 2025 07:59 AM

Reply
4 replies

Aug 31, 2025 11:06 AM in response to a brody

Good morning AB,


It may be better to wait out the MS forums. Some companies like to do site maintenance on Sundays.


I use Excel/Mac a lot but this is not familiar at this point. Can you post a screenshot of how this looks in the cell and formula bar? Maybe I can see something familiar.


Allan


PS: Grandson's 7th birthday today so I'll be away from the computer until this evening.


Microsoft Excel 16.78 pasting double quotes

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.