How to delete in lines with certain characters - everything is superfluous, except for these characters?

Question

Notepad++

Example:
ayyyellow
234234red
dulvyellow
red99
green223
In the above list, for example, I need to clean up extra characters in the lines containing the word "red" (so that only "red" remains), but the rest of the lines should not be affected. How can it be implemented?
Notepad

Answer 1

Find: (?m-s)^.*(красный).*
Replace:\1

Answer 2

Excel has a "text by columns" function, where you can specify an arbitrary separator. Only the rows you need will be affected.
https://support.office.com/en-us/article/%D0%A0%D0...
After separation, this function may also be useful
https://support.office.com/en-us/article/%D0 %9E%D0...