Copy Paste Test from Excel Sheet without " Apostrophes

Max Mustermann

I have A excel table where I have in F1 the following Formula

=“<tr>
<td id=‘td0’>”&A1&“</td>
<td id=‘td1’>”&B1&“</td>
<td id=‘td1’>”&C1&“</td>
<td id=‘td1’>”&D1&“</td>
</tr>
"
&IF(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LEFT(A1;1);“Ü”;“U”);“Ö”;“O”);“Ä”;“A”)=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LEFT(A2;1);“Ü”;“U”);“Ö”;“O”);“Ä”;“A”);”“;”
<tr>
<td colspan=4><a name=‘“&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LEFT(A2;1);“Ü”;“U”);“Ö”;“O”);“Ä”;“A”)&”’> - “&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LEFT(A2;1);“Ü”;“U”);“Ö”;“O”);“Ä”;“A”)&” - </a> - [<a href=‘#top’>Top</a>]</td>
</tr>
"
)

When I copy paste the result from Excel F1 Cell to Notepad++ it copies it with Apostrophes.

"<tr>
<td id=‘td0’>Abbauhämmer</td>
<td id=‘td1’>3</td>
<td id=‘td1’>100</td>
<td id=‘td1’>1.18.7</td>
</tr>
"

Is there a way to copy paste the pure text without the Apostrophes, in order that it looks like this ?

<tr>
<td id=‘td0’>Abbauhämmer</td>
<td id=‘td1’>3</td>
<td id=‘td1’>100</td>
<td id=‘td1’>1.18.7</td>
</tr>

Claudia Frank

Hello @Max-Mustermann,

Excel is responsible what goes to the clipboard and npp gets it from
the clipboard.

What you can do, if the double quote is unique, to record a macro to
find and replace double quote with nothing once and rerun it whenever you need it.

Cheers
Claudia