@Mark-Anderson said in Find Text Copied From Excel Cell:
I understand there are line-ending characters in my data in the second screenshot, but I didn’t put them there
You didn’t knowingly put them there.
In v8.8.6, Notepad++ implemented a long-requested feature, where if you select multiple lines, it would be able to all go in the FIND WHAT box, rather than just a single-line’s worth. To do that, Notepad++ had to start honoring the newlines that were in selected text. This was a good thing for most, BUT not for situations like yours.
Specifically, now, when you select an entire line before doing FIND, if your selection includes the newline – and it usually does, especially if you use the margin-click or triple-click, as shown in the screenshots below – then the search string contains the newlines that you didn’t notice.
399c5a90-5284-4715-8133-511f0fc22c47-image.png
-> in this condition, the newline sequence is selected, though you might not notice it, and you won’t see it in the FIND WHAT at first.
vs
71213e9b-5ce4-4727-b59f-0697b2f71d90-image.png
-> in this condition, the newline sequence is NOT selected, so those characters won’t be in the FIND WHAT box.
But by default, the FIND WHAT does not show the newline characters. So you cannot see that they are there. But they are, because you (unknowingly) selected the newline characters when you selected the whole line.
But, after you run the Search Mode = Normal search, then since there’s newline characters, Notpead++ converts from Normal to Extended, and starts showing the newline sequence, as reported in the old closed-bug-report #11847. The advice that @Alan-Kilborn gave in a related recent issue a few days ago still holds for you as well.