Remove all numbers from excel cells in worksheet

I need to remove all numbers from an excel spreadsheet

I have tried some different vba formulas but none of them work- it ends up just removing 1 number from the cell when I want to remove all numbers.

Any suggestions that would be easier than creating a formula in vba?
Who is Participating?
TracyConnect With a Mentor VBA DeveloperCommented:
Try this, found here:


Function RemoveNumeric(Rng As String) As String
Dim Tmp As String
Dim i As Integer

Tmp = Rng
For i = 0 To 9
Tmp = Application.Substitute(Tmp, i, "")
Next i
RemoveNumeric = Tmp
End Function

Open in new window

Unless I misunderstand your intent, wouldn't a Find and Replace do what you need?  Just search for all 0s and leave the Replace field blank.  Then search for all 1s and so forth.  You could even record a basic macro to do this with one swoop.

As long as your search requirements don't include the whole field, this should work.

If I don't fully understand your need, let us know.
CanalInsAuthor Commented:
Thank you- it worked!!!
All Courses

From novice to tech pro — start learning today.