How to remove specific text from multiple cells in excel

You can use the following basic formulas to remove specific text from cells in Excel:

Method 1: Remove One Specific Text

This particular formula removes “text1” from cell A1.

Method 2: Remove Multiple Specific Texts

This particular formula removes “text1, “text2”, and “text3” from cell A1.

The following examples show how to use each method in practice.

Example 1: Remove One Specific Text

Suppose we have the following column in Excel that shows the position for 15 different basketball players:

We can use the following formula to remove “r” from every position name:

We can type this formula into cell B2 and then copy and paste it down to every remaining cell in column B:

Notice that the “r” has been removed from every position name.

Example 2: Remove Multiple Specific Texts

Suppose we have the following column in Excel that shows the username for 10 different pe

how do i delete partial text in excel

how to remove partial text from a column in excel