How to remove letters from Excel cells
Excel is a powerful tool that can help you manage and analyze data efficiently. One of the basic tasks in Excel is to remove a letter or character 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 above which contains Car Name and Number Plate. There are some useless letters in the Number Plate column. We will remove them using two different methods but first let’s have a look at the dataset.
Method 1: SUBSTITUTE the letter
Step 1 – Type the formula.
- Select the cell where you want to type the formula.
- Syntax of the formula is:
=SUBSTITUTE(Cell_Address, “Letter_to_Replace”,”To_replace_letter_with”)
- In our case formula will be:
- =SUBSTITUTE(B2,”A”,””)
Step 2 – Apply formula to the rest of the cells
- Select the cell with formula.
- Drag the cell from bottom right to the rest of the cells.
- Formula will be applied automatically.
Method 2: Using Find & Select.
Step 1 – Select the cells.
- Select the cells from which you want to remove useless letters.
- Open Find & Select drop down menu in Home tab in Editing group then click on Replace .
- For shortcut you can press Ctrl + H, it will open the same menu that is opened when you click on Replace in Find & Select.
Step 2 – Type the character you want to replace.
- When we click on Replace in Find & Select or Ctrl + H, the Find and Replace menu will appear.
- We will type the letter to replace in Find what blank space.
- Type the character or leave it empty if you want nothing to be replaced with the letter in Replace with blank space.
- Click on Replace All.