:Use substitution to quickly delete content-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. Use substitution to quickly delete content

Use substitution to quickly delete content

Author: daogeziyuan • • Table skills • Views 897
  • Image and text skills


Sometimes there will be continuous repeated data in the table. In some cases, we do not need this content, so we need to delete the repeated data.

But deleting them one by one would be too cumbersome. How to find and delete these duplicate records in the fastest way?

The following is an introduction to you.


3592b69993a8f8fe8457be47405e9cd8.png


￭For example, in this score table, in the column "Test Scores", I want to delete the redundant "Grade:" content.

At this time, we can use replacement for quick deletion.


图一.png


￭First select the "Test Scores" list, hold down "ctrl+h" to bring up the find and replace dialog box, and enter "Grades: " in the search content item.

ReplaceReplaceEnter no content and click "Replace All".


图二.png


￭At this time, in the test results column, the redundant text has been deleted, leaving only the scores.


图三.png


Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/qiao-yong-ti-huan-kuai-su-shan-chu-nei-rong.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu xu Columnist
48 196
single-end

Related Suggestion