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.