How to find and replace multiple strings that are contained in one Excel cell?

Question

excel

Initially in an Excel cell goes like this:

<tr>
    <td>Цвет корпуса</td>
    <td style="width:160px">Белый</td>
    </tr><tr class="sp">
    <td colspan="2">&nbsp;</td>
    </tr>

Please tell me how to remove this part in the cell:

<tr class="sp">
    <td colspan="2">&nbsp;</td>
    </tr>

Search-replace does not work, more precisely, it does not find it in any cell at all, and I have about 3,000 of them.
Maybe there are some macros, functions, I don’t know at least something ..
Thanks in advance!

Answer 1

2 options.
1. In Excel, you need to insert a newline character into the search (which is alt + enter inside the cell). You can’t just insert it into the search, you have to press CTRL + J. But at the same time, the text input field does not increase, so it is very inconvenient to accurately search for a place to enter an invisible character, especially considering that you have a lot of empty spaces there.

excel GIF

.
2. Insert into word (it's clearer there), replace, paste back into Excel.
In Word, the line separator character is "line break", put through a "special format"

Word picture

Word GIF

Answer 2

скорее всего, что у Вас включен режим "перенос по словам"
Отключите его для всех ячеек листа (это также позволит ускорить работы excel)
Потом пробуйте поиск и замену
А вообще, макросами все можно