How to quickly delete the first few identical words in a column in Excel

1. For example, the data in the figure below. The first 3 characters of each cell data are the same.

2. Remove three identical characters "gdv" at once. Check all data units.

3. Click the "Data" tab again; Then click on "Split". The column wizard pops up, click Fixed Width, and then click Next.

4. After clicking "Next", go to the second page of the "Split Wizard". Then, place your mouse as shown in the image below and click on the "v" character on the right side, which shows the upward arrow line.

5. Go to the next step. Go to the third page of the list. Then click "Do not import this column (skip)"; Click Done.

6. When the point is complete, the column wizard will close. The data has been removed from the first three characters "GDV".

Scale your content in column A, remove the first 4 words.

Two methods. 1. Separate method.

Select Column A menu Data Column Select by fixed width and the rest by 2, formula method.

Find an empty column, such as column x, and enter the formula.

Enter at x2.

right(a2,len(a2)-4)

Pull-down padding.

You can use the "Replace" function of the "" menu to enter the text you want to delete in the "Find content" field, and the "Replace with" field is empty, and then you can delete the found text after replacing all of them.

Use the replace function, select the replacement area, press CTRL+H, find the text you want to replace, replace with empty place, replace all.

Use the Data Separation feature.

Summary. How to remove the same word in the same column in excel? You can delete it by substitution.

Here's how:

1. First of all, open the document that needs to be processed, and use the mouse to select the column that needs to be processed.

2. After that, find "Start Options" at the top and click on the option.

3. After that, find the "Find & Select" option on the far right side of the start taskbar and click on it.

4. In the secondary menu that pops up, click the "Replace" option to enter the replacement interface.

5. In the interface, write "other remarks" in the search content column, and replace it with a column without entering any content. When you're done.

Click Replace All in the bottom left corner.

6. After the system completes the replacement, it will prompt that 6 replacements have been completed, and then there are no other remarks in column A.

How to remove the same word in the same column in excel?

How to remove the same word in the same column in excel? You can delete it by substitution. Here's how:

1. First of all, open the document that needs to be processed, and use the mouse to select the column that needs to be processed. 2. After that, find the "Start Option" at the top and click on the option. 3. After that, find the "Find & Select" option on the far right side of the start taskbar and click on it.

4. In the secondary menu that pops up, click the "Replace" option to enter the replacement interface. 5. In the interface, write "other remarks" in the search content column, and replace it with a column without entering any content. When you're done, click Replace All in the bottom left corner.

6. After the system completes the replacement, it will prompt that 6 replacements have been completed, and then there are no other remarks in column A.

If my answer is helpful to you, please give a thumbs up (comment in the lower left corner), look forward to your like, your efforts are very important to me, and your support is also the driving force for my progress. If you feel that I am satisfied with the answer of Fu Lu, you can click on my avatar for one-on-one consultation. Finally, I wish you good health and a good mood!

Take Excel2016 as an example, there are the following steps:

1. Open an excel**, as shown in the figure below:

2. Enter a column of numbers, as shown in the figure below

3. Enter the equals sign in the column where you want to get the result, as shown in the figure below

4. Enter the formula, right(a1,len(a1)-2), as shown in the following figure:

5. Wait until the result, as shown in the figure below

6. Drag this formula to get the result of a column, as shown in the figure below: Nana.

1. First, we open the excel on our computer, and then we enter some numbers in it, and then we select the cells of these numbers, and then we click on the number to open the data.

2. After that, click Delete Duplicates.

3. On the pop-up interface, click OK.

Tools Raw materials.

Excel2016, computer.

1. Turn on the computer to find and click on the Excel2016 version of the software;

2. After opening the excel software, in order to better demonstrate, create a new content in the document and select the content with duplicates;

3. After selecting the content that needs to be deleted, click the "Data" command in the upper toolbar;

4. After selecting the data command, click "Delete Duplicates" below;

5. After clicking, click "Select All" and "Delete Duplicates" in the pop-up dialog box;

6. After selecting and confirming, the duplicate content on ** has been successfully deleted, and one item is retained.

Excel2003 Deduplication and Duplicate Row Method:

Case 1: The content of the duplicate row is exactly the same.

As you can see in the image below, the content of lines 2 and 4 is exactly the same:

Same content. How it works:

Select all the records in the table (note that the header row of each column should also be selected at this time, otherwise the header row will no longer be included in the filtered data table), and run the "Filter" command in the "Data" menu "Filter Advanced Filtering"; In the pop-up "Advanced Filtering" dialog box, select the item "Copy the filter results to another location", and click the range button behind the "Copy to" selection box to select a region to store the filtered data (note: this must not coincide with the cell where the original data is located, otherwise the data table will be messed up), finally, check the "Select non-duplicate records" checkbox, and click the "OK" button.

The detailed operation is shown in the following animation:

Data Deduplication demo animation.

Scenario 2: The content of one column is duplicated between rows, and the content of other columns may be inconsistent.

At this point, we want to use a column condition to find duplicate content and delete the entire row where it is located. As shown in the figure below:

There is duplicate data in a column or row.

We only need column A (i.e.: name column) with no duplicates.

Operation method: 1. Add a new column e, and enter a numeric equidifference sequence (such as ??Drag the manual handle to you.

2. Sort the table by column A.

3. Enter the formula in F2: =IF(A2=A1,"Repeat"，"Drag the manual handle to copy the formula down to the corresponding row.

4. Select all the tables, "Data Auto Filter", select Column F "(blank)", so that there is no duplicate data filtered.

5. Copy the filtered table and paste it into another worksheet.

6. Sort the whole table by column E, restore the original order of the data, and then delete column E.

The detailed operation is shown in the following animation:

Excel Remove Duplicate Lines Demo Animation.

Excel2007 Remove Duplicate Rows and Duplicate Data Method:

Nowadays, deduplication in Excel2007 is a very simple thing, and there is a "delete duplicates" function.

Excel2007 deduplicates.

Select the "Data" tab and click the "Remove Duplicates" button in the "Sort & Filter" area.