Wanted: Delete redundant double quotes of concatenated strings!

[ahankhah]

Hi everybody,

When I use concatenate function to combine two sentences (or words) in one cell with two rows, it is not as I want.

the following is a table in which first row shows the source code and the second row shows issued code. (I used directly texts instead of refers to cells just to simplifying the problem.)

=CONCATENATE("S1= ",CHAR(34),"string1",CHAR(34),CHAR(13),CHAR(10),"S2= ",CHAR(34),"string2",CHAR(34))​

S1= "string1" S2= "string2"​

In Excel, the result looks fine, but when I copy the cel contents to other place (i.e. notepad), these are written this way:

"S1= ""string1""
S2= ""string2"""

How can I delete additional double quotes and get this:

S1= "string1"
S2= "string2"


I appreciate any reply.

 

[VBE313]

Do you want to delete the extra quotations in NotePad?

 

[ahankhah]

Do you want to delete the extra quotations in NotePad?

Of course no,
that was just an example to show the extracted data has extra quotations.

I want make some batch commands and send them in group into Command prompt.

 

[BobUmlas]

Pasting into Word looks fine. Notepad it does not. That doesn't help, but if you paste to Word, then copy from Word and paste into Notepad, then it does look fine!

 

[ahankhah]

Pasting into Word looks fine. Notepad it does not. That doesn't help, but if you paste to Word, then copy from Word and paste into Notepad, then it does look fine!

Thank you very much.

That's working, but I am seeking a method to make batch commands, then run them by sending to command prompt within Excel and without "copy&paste".