vba remove numbers from string

The solution for “vba remove numbers from string” can be found here. The following code will assist you in solving the problem.

lngLastC = .Range(“C65536”).End(xlUp).Row
Dim rn As Integer
rn = 1
ReDim strName(intNumRunners)
For Each rngRunners In .Range(“C3:C” & lngLastC)
strName(rn) = rngRunners.Value
[B]strName(rn) = Replace(strName, IsNumber, “”)[/B]
strName(rn) = RTrim(strName(rn))
rn = rn + 1
Next rngRunners

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts