search for a text without including the strikethrough text

[Crashingtnt]

I am searching for a specific word in the text but i only need cells that dont have the strikethrough effect. But no matter what i change the strikethrough text is still shown as a result

 

[Joe4]

Welcome to the Board!

Native Excel functions only work on actual values. They do not typically work on formatting attributes applied to the cells (formatting only affects appearance, not actual values in the cells).
To do what you want will probably require VBA.

If you would like a VBA solution, please post an example of the data you are working with along with the expected results.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.