Using wildcards to extract data and sharing skills in Word

The original title: "easier to use than Excel!" Efficient office skills, kneel after watching! "

The data in the cell is very messy, there are Chinese, English and numbers, how to extract only part of the content? With functions or VBA? I believe that many Xiaobai friends will not, will not matter, here Xiao Wang teacher to recommend a very simple and practical technique, with Word, let's see how to operate it!

As shown in the following figure:

Extract data first select the data cell, and then copy it to Word, and use "Ctrl + H" in Word to open find and replace.

What to find: [! 0-9]

To be replaced by: empty

Check "wildcard" and finally "replace all".

Description: exclamation point in Word wildcard [!] It means "no" or "no". "0-9" contains all the numbers. What we are looking for here are non-0 to 9 characters.

We extract letters in the same way, and then we extract letters.

Find: [! a-zA-Z]

Replace: empty

Note: [Amurz] contains all lowercase letters, [Amurz] contains all uppercase letters, and [a-zA-Z] contains all lowercase and uppercase letters. And an exclamation point! Except for the letters.

Extract words. Finally, we will extract Chinese characters.

Find: [! One-two] or [! One-two]

Replace: empty

Description: [! One-two] or [! What does it mean? it contains all the Chinese characters, belonging to the order of the 2.0 and 3.0 character sets. You can understand it as 0 to 9 in the numbers, or a to z in the letters, that is, all the Chinese characters.

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi