search
HomeTopicswordSharing practical Word skills: cleverly use 'Find and Replace” + 'Wildcard” to extract data

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!

Sharing practical Word skills: cleverly use 'Find and Replace” + 'Wildcard” to extract data

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.

Sharing practical Word skills: cleverly use Find and Replace” + Wildcard” to extract data

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.

Sharing practical Word skills: cleverly use Find and Replace” + Wildcard” to extract data

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.

Sharing practical Word skills: cleverly use Find and Replace” + Wildcard” to extract data

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.

Sharing practical Word skills: cleverly use Find and Replace” + Wildcard” to extract data

Final effect:

Sharing practical Word skills: cleverly use Find and Replace” + Wildcard” to extract data

【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!

Sharing practical Word skills: cleverly use Find and Replace” + Wildcard” to extract data

#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!

Statement
This article is reproduced at:部落窝教育. If there is any infringement, please contact admin@php.cn delete
实用Word技巧分享:表格自定义样式,美化表格!实用Word技巧分享:表格自定义样式,美化表格!Jul 20, 2022 am 10:25 AM

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

Word与Excel联动:表格借用Word进行分栏打印!Word与Excel联动:表格借用Word进行分栏打印!May 07, 2022 am 10:28 AM

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

实用Word技巧分享:使页面自动滚动实用Word技巧分享:使页面自动滚动May 02, 2022 am 10:00 AM

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

实用Word技巧分享:设置字符间距、行距和段落间距实用Word技巧分享:设置字符间距、行距和段落间距Apr 26, 2022 am 10:25 AM

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

实用Word技巧分享:脚注和尾注的设置、转换和删除实用Word技巧分享:脚注和尾注的设置、转换和删除Jul 21, 2022 am 10:29 AM

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

实用Word技巧分享:【F4】键快速统一图片大小实用Word技巧分享:【F4】键快速统一图片大小Jun 07, 2022 am 10:27 AM

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

实用Word技巧分享:表格中如何自动添加编号实用Word技巧分享:表格中如何自动添加编号Apr 22, 2022 am 09:44 AM

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

实用Word技巧分享:如何快速输入货币、版权符号!实用Word技巧分享:如何快速输入货币、版权符号!May 20, 2022 am 09:42 AM

在之前的文章《实用Word技巧分享:轻松输入省略号的几种方法》中,我们了解了轻松输入省略号的3种方法。今天继续实用Word技巧分享,聊聊输入货币、版权符号的最快技巧,赶紧学起来!

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

Hot Tools

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

ZendStudio 13.5.1 Mac

ZendStudio 13.5.1 Mac

Powerful PHP integrated development environment

VSCode Windows 64-bit Download

VSCode Windows 64-bit Download

A free and powerful IDE editor launched by Microsoft