People who often use Office know that Excel has a search and replace function, which can delete or replace the same word in a table in batches. However, when we have many Excel files that need to delete a word in batch, it is obvious that we cannot search and replace them one by one, which is too low in efficiency. Here is a simple and efficient method to delete the specified text content in multiple Excel files in batch with one click.
Many Excel files to delete the same word usage scenario
1. If each Excel file contains redundant words or symbols, it must be deleted uniformly. For example, the price in each data table is followed by a symbol such as "yuan, dollar" or "ï¿¥, $", which needs to be removed in batches. This can make the data more concise and intuitive, but also more convenient to calculate.
2. When we want to merge several Excel tables, if the content format in the table is not uniform, we must delete some words in batch and unify the content format. For example, the first column of each file is "sample name_01, sample name_02, sample name_03", we will delete the suffix in batch.
Excel table delete the specified text after the effect preview
before treatment:
after treatment:
Batch delete Excel table specified text operation steps
1, open. HeSoft Doc Batch Tool , select Excel Tools → Find and replace keywords in Excel.
2. Add the Excel file to be processed. There are three ways to add files: add files, import files from folders, drag and drop directly, and choose one of them.
3. Processing range selection cell text; Cell data type selection text. Other option settings can be selected according to their own needs. Select the exact search text and enter the text to be deleted in the list on the left. If it is not entered on the right, it will be deleted.
4. After the processing is completed, directly click the save location to view, and all the specified text in the Excel form is deleted.
What are the advantages of using this tool?
ordinary search and replace can only delete or replace the contents of a single file. If you encounter a lot of files, you can only operate manually or through VBA macro processing. But for the ordinary office family, VBA is too difficult, do not understand the code is very easy to make mistakes. The use of professional batch processing tools, not only can process thousands of files at one time, but also simple operation, novice Xiaobai can easily solve the problem of batch replacement text.
Is this tool useful?
HeSoft Doc Batch Tool The interface is simple and the operation steps are very short. Basically, it can be done in 2-3 steps. There is no technical threshold. People who are not familiar with Office or Excel can easily use it. Moreover, it can handle a variety of file types, such as Word, Excel, PPT, PDF, TXT, pictures, etc. There is no upper limit on the number of files. Tens of thousands of files can also be imported into the tool with one key for batch processing, saving time and effort, and easily improving efficiency!