Shulou(Shulou.com)06/03 Report--

Today, I will talk to you about how to remove the first few characters in EXCEL in batches, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

The solution to batch removal of the first few characters in EXCEL: first select all data cells and click "separate"; then place the mouse to the right of the word "V" and click to show an upward arrow line; finally, click "do not import this column (skip)".

For example, the data in the following figure.

The first three characters of each cell data are the same.

Delete the three same characters "GDV" in batch at one time.

Select all data cells.

Click the "data" tab again, and then click "separate".

Pop up the sorting wizard, click "fixed width", and then click "next".

After clicking next, go to the second page of the sorting wizard.

Then, the mouse is placed under the point to the right of the word "V" as shown in the following figure, which shows an upward arrow line.

Click on the next step.

Go to page 3 of the catalogue. Click "do not import this column (skip)"; click finish again.

When the point is complete, the sorting wizard closes. The first three characters "GDV" have been removed from the data.

After reading the above, do you have any further understanding of how to batch remove the first few characters in EXCEL? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.