Question : vba remove numbers from string
Answered by : mysterious-magpie-e3i20dfpp0dy
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 rngRunnersSource : https://www.ozgrid.com/forum/index.php?thread/36659-remove-numbers-from-a-string/ | Last Update : Thu, 09 Apr 20