Find and Replace loses cell formatting in Excel

There have been multiple posts over the years about this issue, when is Microsoft going to fix this bug?   Example: cell contains:  dogs are the best Find dogs, replace with cats result should b...