In Today’s video, I show you how to use the Excel Find and Replace functionality to replace just the values you need to. Need to replace cells with just zero (0), but do not want to affect the cells that just happen to also contain zero (0). This neat #Excel Find and Replace trick shows you how. Use the Match Entire Cell Contents option in Find and Replace.
My Recommended Pivot Table Course:
http://www.mothresource.com/152-27-1-41.html
Join me EVERY FRIDAY for #formulafriday and EVERY MONDAY for #macromondays on the http://www.howtoexcelatexcel.com blog for lots of #exceltips
Join thousands of other Excel users who have already joined the Excel At Excel Monthly Newsletter. 3 FREE Excel Tips every month. Plus FREE 30 Tips EBook.
http://www.howtoexcelatexcel.com/newsletter-sign-up/
Be Social & Let’s Connect
++Website http://www.howtoexcelatexcel.com
++Twitter https://twitter.com/howtoexcelatex