Ignore non-numeric characters in a string

[smpita]

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

Please Login or Register  to view this content.

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!

[tigeravatar]

If the letters are always after the number, you could Val():

Please Login or Register  to view this content.

[smpita]

Thank you tigeravatar! Lucky for me, the letters are always after the numbers. Val() did the job great!