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.)
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.
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.