Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to 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.
70 Views
