The solution to batch removing the first few characters in EXCEL: first select all data cells and click "Sort into Columns"; then place the mouse on the right side of the "V" and click, an upward line will appear. arrow straight line; finally click "Do not import this column (skip)".
#For example, the data in the figure below.
The first three characters of each cell data are the same.
Delete the three identical characters "GDV" in batches at once.
Select all data cells.
Then click on the "Data" tab; then click on "Column".
In the pop-up column wizard, click "Fixed Width", and then click "Next".
After clicking Next, go to the second page of the Sorting Wizard.
Then, place the mouse on the right side of the "V" as shown in the picture below, and an upward arrow line will appear.
Click Next.
Go to the third page of the list. Then click "Do not import this column (skip)"; then click Finish.
After clicking Finish, the Sorting Wizard closes. The data has removed the first three characters "GDV".
More tutorials:"Web Front-end Tutorial"
The above is the detailed content of How to remove the first few characters in batches at once in EXCEL. For more information, please follow other related articles on the PHP Chinese website!
