How to batch modify documents in wps with one click Share the method of batch modifying documents in wps with one click

WBOY
Release: 2024-08-21 14:08:44
Original
926 people have browsed it

How to batch modify documents in WPS with one click? Sometimes we need to process a lot of files during office work, and the efficiency of modifying them one by one is very slow, which makes it possible to use the one-click batch modification function of documents in WPS, but few people know how to use it. Today’s content is about Let's share the specific operation method and let's take a look at the specific content. Method step 1. First open the Excel file, taking the following table content as an example.

wps怎么一键批量修改文档 wps一键批量修改文档方法分享

2. Click on cell C2, click [Formulas] - [Common Functions] in the menu bar, enter REPLACE in the search box of [Find Function] and click the [OK] option.

wps怎么一键批量修改文档 wps一键批量修改文档方法分享

3. Next set the function parameters:
  • Click B2 cell meta text mobile phone number in the original string in the pop-up dialog box.
  • Enter 4 in [Start Position] (the position we want to modify starts from the 4th number).
  • Enter 4 in [Number of Characters].
  • Enter: ** in [New String]. It should be noted that double quotes should be added here for reference, and then click [OK].

    wps怎么一键批量修改文档 wps一键批量修改文档方法分享

    4. At this time, the hidden mobile phone number in the first cell has been completed. We only need to move the mouse to the right side of cell C2 and pull down.

    wps怎么一键批量修改文档 wps一键批量修改文档方法分享

    5. As shown in the picture below, what is finally presented to us is the batch modified content.

    wps怎么一键批量修改文档 wps一键批量修改文档方法分享

The above is the detailed content of How to batch modify documents in wps with one click Share the method of batch modifying documents in wps with one click. For more information, please follow other related articles on the PHP Chinese website!

source:xpwin7.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template