ADVERTISEMENT
ADVERTISEMENT
I agree, that is why I prefaced it with:jmiskey,
That will work if length is the only other factor involved, but it may not work if the values are the same length with different text or numeric values.
It should work if they all start with "c" and then are followed by the number. If there are other conditions/possibilites, they need to identify them, and then we can modify/create the solution from there.Here is a possible workaround that works for the data you provided.
Function StripNumbers(myValue) As Long
Dim i As Integer
For i = 1 To Len(myValue)
If IsNumeric(Mid(myValue, i, 1)) Then
StripNumbers = StripNumbers & Mid(myValue, i, 1)
End If
Next i
End Function