HOW TO DELETE THE LAST THREE WORDS IN A COLUMN OF TEXT IN EXCEL

Divide the columns first, and then delete the three words in a column, for example:

1.For example, now you want to add a string in cell A1.

Test, old, sen, y, u, 1 "according to the comma", to sort.

See diagram below. <>

2.Select cell A1 and click the "Column" button in the "Data" tab.

See diagram below. <>

3.In the Text Column Wizard that pops up.

Step 1: Select the "Divider".

Click "Next".

See diagram below. <>

4.In the Text Column Wizard that pops up.

Step 2: Tick before "comma".

Click "Next".

See diagram below. <>

5.In the Text Column Wizard that pops up.

Step 3: Click "Done".

See diagram below. <>

6.In this way, the strings "very, old, sen, y, u,1" in cell A1 have been sorted by comma",".

See diagram below. <>

7.If you want to delete the last three words, you can directly select the column to delete it.

There are two ways to do this: 1 is to replace with lookup, find how are you, replace with nothing, and replace them all. 2. Use the formula to copy the formula if your text is in column A b2=left(a2,len(a2)-3).

Find Replacement, select Replace All,

1. Open Excel** on the computer, and remove the last three words in each cell.

2. Enter the formula =left(f7,len(f7)-3), 3 is to remove 3 numbers.

3. After entering the formula, press the enter key to remove the last three words.

4. Pull down and copy the formula to dismantle the smart shot.

1. Select column B, and click "Data" - Columns.

2. Click "Next" in the pop-up window. Wantonly.

3. Check "Other" to enter the "Symbol" you want to remove, and click "Next".

4. Click "General" in the red circle in the picture below, and a black background will appear in the selected place after clicking.

5. Select "Do not import this column" and click "Split World Lu Complete" in the lower right corner.

6. Only the name remains.

1. Open Excel** on the computer, and remove the last three words in each cell.

2. Enter the formula =left(f7,len(f7)-3), 3 is to remove 3 digits.

3. After entering the formula, press the enter key to remove the last three words.

4. Drop down and copy the formula.

Let's say you want to delete the content after "", then.

Method 1: Use the Find Replacement method.

Press Ctrl+H

Enter * in the lookup

Write in replacement

Replace them all. Here the * sign is used as a wildcard, which can replace multiple characters.

Method 2 is done with a formula.

Suppose the data is written in cell A1, then another cell is written to the formula =left(A1,find("★",a1))

Just use left.

left(a1,len(a1)-2), remove the last two characters.

1. Since the excel2010 version as an example, as shown in the figure below, we want to delete the same bai in this column

the word "day"; 2. First press the ductrl+h key to bring up the replacement setting box, fill in "day" for the search content, replace it with no dao, and then click "replace all" in the lower left corner;

3. Click "OK" in the pop-up replacement result prompt box;

4. You will see that the words in the data have been deleted, and then click "Close" in the Find and Replace box.

Select the column you want to replace, and click "" in the menu bar of DuExcel software

Click "Replace" in the drop-down menu version, and click "Options" in the pop-up window. In the Find content box, enter the characters you want to remove, and don't enter them in Replace. Click on "Options".

First, first of all, open the excel program, love to open the excel program to open the file to be operated.

2. After returning, press "CTRL+H" on the keyboard to bring up the answer and replace dialog box.

3. Then, enter the word you want to replace in the "Replace Dialog", replace it with "space", and click Replace.

Fourth, finally, you can see that the deletion of the same word in a column is completed, and the problem is solved.

Select this column of data and ctrl+h to bring up the replacement dialog.

Enter the word you want to delete in the search content, don't enter anything in the replace with, just click Replace All.

1. The software used in this demonstration is Excel Electronic**, and the version used is Microsoft Office Home and Student Edition 2016.

2. First of all, open Excel Electron** and enter the data used to demonstrate the batch deletion of the first three words.

3. Select the data you want to do in batches, find the column button in the toolbar, select the column by width in the window that pops the trapped car, and then move the column finger to the position of the three-word sail hall.

4. Finally, click OK to close the window, you can see that we have deleted the first three words of the data in Excel in batches.

The steps to delete the first three words in Excel in bulk are as follows:

The first Wang ordered to open Excel Electron** first, and enter the data used to demonstrate the batch deletion of the first three words.

Select the data that you want to perform batch operations on.

Find the Column button in the toolbar, select Column by Width in the pop-up window, and move the column pointer to the position of three words.

Click OK to close the window, and you can see that the first three words have been deleted in batches from the data in Excel.

The above is only the basic steps, the actual operation may be different due to different excel versions, if you encounter problems, it is recommended to consult a professional.