How to remove specific text from Excel cell

Excel is a powerful tool that can help you manage and analyze data efficiently. One of the basic tasks in Excel is to remove specific text from a cell. This can be useful when you have a large dataset and need to remove a specific letter or character from a column. In this tutorial, we will show you how to remove a letter from an Excel cell using two different methods.

Here we have a dataset that contains Account Holder’s Name and Email Account. As you can see in the dataset below in the Email Account column “Mail:” is written before every Email address, in this tutorial we will remove it using two different methods. Let’s have a look at the dataset first shown above.

Method – 1 SUBSTITUTE the text.

Step – 1 Type the formula.

  • Select the cell where you want to type the formula.
  • Syntax of the formula is:

=SUBSTITUTE(Cell_Address, “Text_to_Replace”,”To_replace_text_with”)

  • In our case formula will be:


Step – 2 Apply the formula to the rest of the cells.

  • Select the cell with the formula.
  • Drag the cell from the bottom right to the rest of the cells.
  • The formula will be applied automatically.

Method – 2 Using Find & Select.

Step – 1 Select the cells.

  • Select the cells from which you want to remove the useless text.
  • Open the Find & Select drop-down menu in the Home tab in the Editing group.
  • Click on Replace.

Step – 2 Type the character you want to replace.

  • When we click on the Replace in Find & Select, the Find and Replace menu will appear.
  • We will type the text (Mail:) to replace in Find what blank space.
  • Type the character or leave it empty if you want nothing to be replaced with the text in Replace with blank space.