Ticker

6/recent/ticker-posts

Header Ads Widget

Responsive Advertisement

Remove Numbers from a Cell in Excel

 

Method 1: Use Find & Replace with Wildcards to Remove Numbers from a Cell in Excel

In this method, we’ll remove those numbers using the Find & Replace command with the Wildcards.

In this stage, we have some rough numbers closed with parentheses and placed in the Products Names column. We will remove these numbers. So, let’s see the steps below.

Steps:

➤ Select the data range B5:B11.

➤ Press Ctrl+H to open Find & Replace command.

➤ Then type (*) in the Find what box and keep the Replace with box empty.

➤ After that, press Replace All.

Find & Replace with Wildcards to Remove Numbers from a Cell in Excel

Method 2: Apply Find & Select Tool to Delete Numbers from a Cell in Excel

Here, look that there are two cells in the Product IDs column which contain numbers only. Now we’ll remove the numbers from the IDs’ cells using Find & Select command.

Step 1:

➤ Select the data range C5:C11.

➤ Then go to the Home tab > the Editing group > Find & Select > Go to Special

A dialog box will open up.

Find & Select Tool to Delete Numbers from a Cell in Excel

Step 2:

➤ Mark only Numbers from the Constants option.

➤ Press OK.

Find & Select Tool to Delete Numbers from a Cell in Excel

Now, look that the cells, only the numbers are highlighted.

Find & Select Tool to Delete Numbers from a Cell in Excel

Step 3:

➤ Later, just press the Delete button on your keyboard.
Here it is. The numbers are removed.

Now you will spot that all the numbers with the products’ names are gone.

Post a Comment

0 Comments