• Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • More  
    • Blog
    • Download Area
    • Excel Video Tutorials
Home » How Find and Replace Exactly In Excel

How Find and Replace Exactly In Excel

March 18, 2020 by Barbara

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.
find and replace exactly Pin it! Share on Facebook
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

Filed Under: Blog, Excel Tip Category, Excel Tips& Tricks, Quickie Tips Tagged With: Blog, Excel, Excel Tips

Tags

Blog Cells Excel Excel Charting Excel Excel Tips Excel Formulas excel tip Excel Tip Category Excel Tips Excel Tips& Tricks excel tutorials Excel Videos Excel Video Tutorials formatting Formula formula friday Formulas macro Macro Mondays Macros Pivot Table Pivot Tables Power BI Power Query Tutorials vb VBA Worksheets

Recommended Excel Resources

Free Excel Dashboard Webinar

Copyright © 2023 · Enterprise Pro Theme on Genesis Framework · WordPress · Log in

SHARE

Additional Info

Want FREE Excel Tips?

Click on my FREE eBook, its my bonus for joining thousands of others who receive my 3 xFREE Excel tips every month in my Excel Newsletter. Join Us!.

Excel Jobs

Excel Charting

Self Expanding Charts
One Click Charts
Create Quick Dynamic Charts
Easy Combination Charts

privacy policy