Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Using wildcards to extract data and sharing skills in Word

2025-01-21 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > IT Information >

Share

Shulou(Shulou.com)11/24 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 228

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

IT Information

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report