How Find and Replace Exactly In Excel


Hey Excellers. Today I will show you how to use the Find and Replace in Excel. Specifically to replace exactly only the values you need to. This blog post is in response to a question a colleague asked last week. They needed to find all cells that contained zero and replace them with a blank without affecting the zeros appearing in other cells. For example 100, or 1000. Only the cells that contained ONLY 0 needed to be replaced. The solution is really simple, as long as you know which option to take to replace only the specific values you want to.

Using Find and Replace.

  • Open the Find & Replace by Hitting Ctrl+ F or Home Tab | Editing Group | Find & Replace.
  • Select the Replace Tab.
  • Type the value you want to find. In this example, it is 0.
  • In the Replace box leave blank.
  • Select the Options, button, ensure that ‘Match entire cell contents’ is ticked.
  • Hit Ok.
  • Only the cells containing ONLY 0 will be affected. Cells with any other content containing zeros will not be updated.
Job Done!. have you used this Find and Replace options before?.
Did you know there were advanced options with this function in Excel?. Have you used it before?.

Other Related Excel Excel Tips.

Formula Friday -Delete Values From Cells While Keeping Formulas

Proper Excel Formula

Top 3 reasons for your Excel formula showing in a cell and not the result

If you want more Excel tips then sign up to my monthly Newsletter where I share 3 Excel Tips on the first Wednesday of the month and receive my free Ebook, 30 Excel Tips.

Likewise, if you want to see all of the blog posts in the Macro Mondays and Formula Friday Series Click The Link Below

Macro Mondays Blog Posts.

Formula Friday Blog Posts.

Learn Excel Dashboard Course

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts