Copy Paste Test from Excel Sheet without " Apostrophes



  • 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>



  • 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