this is the only blog that got the answer, it turned out to be one of the add ins.thank you
5 Ways to Fix Find and Replace Not Working in Microsoft Excel
Unable to use Find and Replace in Microsoft Excel? Here are some ways to fix the Find and Replace not working issue in Microsoft Excel.
