


In the previous article "Practical Word Tips Sharing: Clever Use of "Wildcards" to Batch Insert Tables", we learned how to use Word wildcards to batch insert tables. Today we will continue to share practical Word skills. Let’s talk about how to use “Find and Replace” and “Wildcard” to extract data. Learn it quickly!
Yesterday, one of our friends left a message in the background and asked this question: the product name and model are mixed together, how to quickly extract the product name, that is, only keep Chinese characters.
Today I will take the opportunity to answer this question and share with you several ways to extract text in Word. You can use Word’s ‘wildcard’ function to assist in data extraction.
1. Extract Chinese characters
Tips: Press the [Ctrl H] key to open the "Find and Replace" dialog box and click "More " button, check "Use wildcards" in the search options, enter [a-z,A-Z,0-9] in the search content, click "Replace All", that is, replace all letters and numbers, and only retain Chinese characters.
Chinese characters can be extracted according to the above method. If you only need numbers or English, how to extract them?
In fact, the extraction method of numbers and English is similar to the extraction method of Chinese characters, but there is a difference when entering the search content.
2. Extract numbers
Tips: Enter [!0-9] in the search content, where the exclamation mark is the logical NOT operator , indicating all parts except 0-9. Click the "Replace All" button to replace all non-numeric content, leaving only numbers.
3. Extract English
Tips: Enter [!a-z,A-Z] in the search content ,where the exclamation point is the logical NOT operator, representing all parts except a-z, A-Z. Then click the "Replace All" button to replace all non-English letter content and keep only letters.
Final effect:
【Today’s Interaction】
If I need to extract numbers and English at once and remove Chinese characters. How should I do this? How to fill in the search content? do you know? Welcome to leave a message at the end of the article to discuss and learn from each other!
#Word Search and Replace The wildcard function is a bit like regular expressions and is very powerful. Here are just a few tips. You can study it yourself!
Recommended tutorial: "Word Tutorial"
The above is the detailed content of Sharing practical Word skills: cleverly use 'Find and Replace” + 'Wildcard” to extract data. For more information, please follow other related articles on the PHP Chinese website!

在之前的文章《实用Word技巧分享:详解怎么更改图片颜色和形状》中,我们了解了更改图片颜色和图片形状的方法。而今天我们来聊一聊word表格,讲解美化表格--自定义表格样式的方法,快来看看吧!

在之前的文章《实用Word技巧分享:聊聊你没用过的“行号”功能》中,我们了解了Word中你肯定没用过的"行号”功能。今天继续实用Word技巧分享,看看Excel表格怎么借用Word进行分栏打印,快来收藏使用吧!

在之前的文章《实用Word技巧分享:设置页码的终极方法!》中,我们学习了Word页码的设置方法。而今天我们来一起聊聊Word文本间距设置的几个技巧,快来收藏使用吧!

在之前的文章《实用Word技巧分享:隐藏图片,提升文档浏览和编辑效率!》中,我们学习了隐藏图片的技巧,可提升文档浏览和编辑效率。下面本篇文章再给大家分享一个实用Word技巧,看看怎么让页面自动滚动,快来收藏使用吧!

在之前的文章《实用Word技巧分享:表格自定义样式,美化表格!》中,我们了解了自定义表格样式的方法。而今天我们来聊一聊word脚注和尾注,介绍一下脚注和尾注的设置使用方法,快来看看吧!

在之前的文章《实用Word技巧分享:怎么跨文档快速复制样式》中,我们了解了在文档间快速复制样式的方法。今天我们聊聊Word快捷键,聊聊【F4】键快速统一图片大小,快来看看吧!

在之前的文章《实用Word技巧分享:如何一键删除所有数字》中,我们学习了Word中一键删除所有数字的方法。而今天我们来聊聊Word表格中如何自动添加编号,简单却很实用!

在之前的文章《实用Word技巧分享:图、表如何自动编号?》中,我们了解了Word排版-让图、表自动编号的方法。而今天聊聊Word精确控制页面“行数”和“字符个数”的方法,快来看看吧!


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function

DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

Atom editor mac version download
The most popular open source editor
