Remove Numeric Characters from Cells in Excel

Excel is an effective programme that enables users to efficiently organise, modify, and analyse data. Excel spreadsheets frequently contain a variety of characters in their data, including numbers, letters, symbols, and more. There are circumstances, nevertheless, in which you might need to clean your data and eliminate all numerical characters from particular cells or columns.

In this tutorial, we'll walk you through many methods for removing number characters from Excel cells step-by-step. This lesson will provide you the skills and knowledge necessary to complete this operation with ease, whether you have a list of product codes, customer IDs, or any other data that has to be cleaned of digits.

Remove Numeric Characters From Cells

Here we can complete the task by creating a VBA module. So let us see a simple process to learn how you can remove numeric characters from cells in Excel.

Step 1

Consider an Excel sheet where the data in the sheet is similar to the below image.

First, right-click on the sheet name and select View code to open the VBA application.

Right-click > View Code.

Step 2

Then click on Insert and select Module, then copy the below code into the text box.

Insert > Module > Copy.

Code

Sub RemoveNum()
Dim Rng As Range
Dim WorkRng As Range
On Error Resume Next
xTitleId = "Remove Numeric Characters"
Set WorkRng = Application.Selection
Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)
For Each Rng In WorkRng
   xOut = ""
   For i = 1 To Len(Rng.Value)
      xTemp = Mid(Rng.Value, i, 1)
      If xTemp Like "[0-9.]" Then
         xStr = ""
      Else
         xStr = xTemp
      End If
      xOut = xOut & xStr
   Next i
   Rng.Value = xOut
Next
End Sub

Step 3

Then click F5 to run the module. Then select the range of cells and click OK to complete the task. Then you will see that numeric characters will be removed.

F5 > Select Cells > OK

Conclusion

In this tutorial, we have used a simple example to demonstrate how you can remove numeric characters from cells in Excel to highlight a particular set of data.