Slider

How to Replace Specific Content in Excel Sheets More Precisely

Date:2020-2-22 Author:Cordelia

Imagine that you have a grade table and need to replace all the “0” scores in it with “Fail”, how can you do it without replacing the “0” in other values like 60, 70? Is there a way to replace the specific content in Excel Spreadsheet more precisely?

It’s a tricky situation cause normally the Find and Replace function will indiscriminately replace the text you input as long as it’s in the sheet. For example, I want to replace all the 0 scores in the form into “Fail”.

How to Replace Specific Content in Excel Sheets More Precisely

Then all the “0” will be replaced whether it’s a single number or not.

How to Replace Specific Content in Excel Sheets More Precisely

To achieve the result that only replacing the score of “0”, you just need to do one more step in the process.

Press [Ctrl+H] to call out the Find and Replace window, input “0” in Find what and “Fail” in Replace with, then click Options.

How to Replace Specific Content in Excel Sheets More Precisely

Check Match entire cell contents. It means the replacing will work only when the content in a cell is completely match the text you input.

How to Replace Specific Content in Excel Sheets More Precisely

Now check the result. Only the “0” scores in this table have been replaced while values like 60, 80 all stay the same.

How to Replace Specific Content in Excel Sheets More Precisely

If you find our content useful, donations are always welcom. we'll keep going and hold more giveaways in the future.

Windows 10: Run Troubleshooter to Fix Network Connection Problems
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *