Hello and thank you for looking at my thread.

I am looking for a way to make excel ignore non-numeric characters in a string.

I have a line similar to 
If Not cell.Value < 9999 Then
where cell is an array (Dim as Range) with a number. Sometimes that number contains a letter which breaks my macro. Is there any easy way to strip non-numeric characters?

eg; Have it treat a variable that could either have the value 1234 or 1234a as 1234. (And 1234 could be any number under 9999)

Thanks in advance!