Practical Word skills sharing: quickly extract numbers from tables with mixed text and numbers

How does Word quickly extract numbers from a table with mixed text and numbers? The following article will introduce to you two methods of quickly extracting numbers. I hope it will be helpful to you!

Although we use Word almost every day, if we study it carefully, we will find many interesting and practical tips that we don’t know.

Here is a test for everyone: In Word, how to extract the values ​​you want from a table with mixed text and numbers? in order to calculate the value. At this time, many people may use copy and paste methods to extract them one by one? NO, NO, NO... Here is a tip recommended to you: Word search and replace function.

For example, quickly extract the pure numbers in the table below.

The reason why these two methods are introduced below is mainly because it is smart enough and is very practical for irregular text and number mixing. I hope everyone will learn about it after reading it. can be applied in practical work.

The specific operation method is as follows:

The first step: First copy the content to the Word document, click [Start] ]-[Edit]-[Replace] button, or press [Ctrl H] to open the "Find and Replace" dialog box.

Step 2: Enter [!0-9] in the "Find content" text box, do not enter anything in the Replace with text box .

Step 3: Click the "More" button and check the "Use Wildcards" checkbox.

Step 4: Click the "Replace All" button to delete the text in the table and retain the values ​​to extract the data.

In addition, we can also use Excel to quickly extract values. EXCEL itself is a tool focused on data processing, so processing large amounts of data quickly is the essence of EXCEL. In EXCEL, I think the fastest extraction method is: [Ctrl E] quick fill, which is really super convenient.

The specific operation method is as follows:

Step one:First, copy the Word table data to the Excel table .

Step 2: Then enter the number you want to extract in one or two cells and press [Enter] to confirm. Then press the [Ctrl E] key to quickly extract the remaining data according to the rules of the first data.

Tips: The real function of the [Ctrl E] key is to fill in data in batches according to certain rules. But it should be noted that this method has version restrictions when used. Currently it can only be operated in Office 2013 or above~~~

Summary: Through the above two methods, you can mix text and numbers. Extract the numbers you want from the table to facilitate the summary calculation of the data.

Recommended tutorial: "Word Tutorial"

The above is the detailed content of Practical Word skills sharing: quickly extract numbers from tables with mixed text and numbers. For more information, please follow other related articles on the PHP Chinese website!