Remove numeric characters in a string

[PATSYS]

Hi all, I have below sample values in column A:

q1w2e3r4
asdqw123
w12345fgh
12cv34yu

Is there a way that a formula in column B will return a value in column A but excluding all the numeric characters?

Thanks in advance.

 

[Devstar]

Here is such a UDF...

Function NoDigits(S As String) As String
  Dim X As Long
  NoDigits = S
  For X = 0 To 9
    NoDigits = Replace(NoDigits, X, "")
  Next
End Function

HOW TO INSTALL UDFs
------------------------------------
If you are new to UDFs, they are easy to install and use. To install it, simply press ALT+F11 to go into the VB editor and, once there, click Insert/Module on its menu bar, then copy/paste the above code into the code window that just opened up. That's it.... you are done. You can now use NoDigits just like it was a built-in Excel function. For example,

=NoDigits(A1)

Sir - please tell how to remove numbers from the end of a string?
Example: dawid1 , Jhon 234, Ben 22
to dawid, Jhon, Ben