Remove Numbers from Alphanumeric String
Hi GarysStudent. Can you explain how to use this? Thanks!
"Gary''s Student" wrote:
Try this UDF:
Function letteronly(r As Range) As String
letteronly = ""
If Application.WorksheetFunction.IsText(r.Value) Then
s = r.Value
For i = 49 To 57
s = Replace(s, Chr(i), "")
Next i
letteronly = s
End If
End Function
--
Gary''s Student - gsnu200751
"Dave" wrote:
Hi,
I have a value in Cell A of ABC123.
I want Cell B1 to contain the 123 from this cell.
Can anyone tell me the formula to enter in B1. I'm sure I've seen it
somewhere before but can't put my finger on it.
Thanks!
Dave
|