标签：find and replace
-
How To Batch Delete Chinese In Word Document
More and more people all over the world are learning Chinese. Many countries have even incorporated Chinese into the national education system and set it up as an examination subject. If you are also learning Chinese, this Word skill really needs to be mastered. When you are learning Chinese, you can look at the Chinese […]
-
How To Convert Negative Number Into Positive Quickly In Excel
If you need to change all the negative numbers in the Excel sheet into positive, what should you do? In today’s tutorial, we are going to learn two ways to convert negative numbers into positive ones. Method 1 Insert Function Select a blank cell and go to Formulas, Choose Insert Function. Choose ABS in the […]
-
5 Ways to Delete Blank Pages in Word Document
When writting, you may find one or more unwanted blank pages in Word. To delete these blank pages which are useless and do affect the layout of your document. Here are 5 effective solutions you can try: Delete the Blank Page Directly 1. If the blank page is in the end of your Word document, […]
-
3 Methods to Wrap Text in Microsoft Excel
Microsoft Excel doesn’t wrap text by default, no matter how much text you enter in one cell. This could lead to the content of cells beside being covered, and finally affect the layout of the entire Excel spreadsheet. To avoid this , you can try these methods to wrap text in Microsoft Excel manually or […]
-
How to Replace Specific Content in Excel Sheets More Precisely
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 […]
-
How to Batch Delete Numbers in Microsoft Word
When editing a document in Word, sometimes we may want to remove the unwantted numbers in it, but deleting them one by one can be very time-consuming. Can we delete all the numbers of Word document in batch? There’s a very simple method. 1. First, go to Home tab and click Replace in Editing section, […]
-
How to Batch Highlight Specific Words or Lines in Microsoft Word
Many of you may have tried the highlight feature of Word to make the specific part of the text stand out. But if there’s a particular word which appears in your document for many times, and you want to highlight them all. How can you do it? Is there a simple way to batch highlight […]
-
How to Calculate the Data in the Same Cell with Excel Formula
Normally we use Excel formulas to calculate the data from different cells, but in some cases we may enter mulitple numbers with operational symbols in the same cell and want to calculate the result, can we still use formula to work it out? Look at this table, There are multiple numbers and operation symbols in […]
-
How to Underline Specific Text Automatically in Word Document
When editing some important files or contracts in Word, you probably need to underline a word or a sentence for many times in the same document, which is very time-consuming and easy to miss. So, is there a way to underline all the specific text in batch automatically? Fortunately, the feature Find and Replace in […]
-
Quickest Way to Replace Text with Picture in Microsoft Word
Today I’d like to share a small trick which can simply replace plain text with pictures. Taking the word “Windows” for example. Assuming it appears in a whole document for many times, and now I want to replace them into the picture below. The first thing you need to do is copying the picture to […]
