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:

=SUBSTITUTE(F2,”Mail:”,””)

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.