How can I prevent Excel from Adding extra quote marks when I paste information out of excel

[psycoperl]

I am working on a project where I am building HTML Code for link lists in Excel and then will copy and paste the completed code into my HTML document. However, I am noticing that when I copy and paste the resulting HTML code out of excel and into any text editor (including the Mr.Excel Forum's Code Editor) that it pre-appends and appends a " at the ends of the string and then doubles any " that are already existing in the code. How can I stop these extra " marks from being added to my string when I cut and paste?

_FileList.xlsx
	F		H	I	J
1	Caption		NORESP_LIST_BUILT	ShareLink	HTML
2	Accountancy (ACC) GRAD			http://test.url/smith?join=1&coder=2	<p style="padding-left:20pt;"><a href="http://test.url/smith?join=1&coder=2" target="_blank">Accountancy (ACC) GRAD</a><br /> <span style="font-size:10pt;word-break:break-all;margin-left:10pt;margin-right:20pt;display:block;"><em>http://test.url/smith?join=1&coder=2</em></span></p>
3	Accounting (ACCT) GGRD
FILELIST

Cell Formulas
Range	Formula
J2	J2	=CONCATENATE(HTMLCODE!A1,I2,HTMLCODE!A2,F2,HTMLCODE!A3,HTMLCODE!A4,HTMLCODE!A5,HTMLCODE!A6,I2,HTMLCODE!A7)

_FileList.xlsx
	A
1	<p style="padding-left:20pt;"><a href="
2	" target="_blank">
3	</a><br />
4
5
6	<span style="font-size:10pt;word-break:break-all;margin-left:10pt;margin-right:20pt;display:block;"><em>
7	</em></span></p>
8
HTMLCODE

Cell Formulas
Range	Formula
A4,A8	A4	=CHAR(10)
A5	A5	=CONCATENATE(CHAR(9),CHAR(9),CHAR(9))

 

[Toadstool]

Hi Psycoperl,

It's your text qualifier. Type some text in a cell and select that cell.
Data, Text to Columns, Delimited, Next, under Text Qualifier select None then Finish.

Your cell should no longer be prefixed/suffixed by double quotes when you paste into another app.

 

[psycoperl]

Ok would this change it just for this file or would it be for all files?

 

[psycoperl]

Unfortunately -- this did not work.

 

[Toadstool]

Sorry, I was pasting the wrong cell.

It's the CHAR(10) and =CONCATENATE(CHAR(9),CHAR(9),CHAR(9)) which makes Excel wrap it in double quotes.
I can't see a way to avoid that if the string must contain control characters.

 

[psycoperl]

Sorry, I was pasting the wrong cell.

It's the CHAR(10) and =CONCATENATE(CHAR(9),CHAR(9),CHAR(9)) which makes Excel wrap it in double quotes.
I can't see a way to avoid that if the string must contain control characters.

Ok. thank you for the guidance. I used the app BBEDIT to clean up the Prepending and Appending quote marks as it has a function to clean up lines of code.

I will try to remember this going forward.