Remove text from string, return numbers

I have data in the N column (N6:N1000). Some of this data has letters after the numbers ("WH", "-WH", " BG", etc)
obviously these cells will not be included in an sum formulas as they register as text strings. I need a VBA code that will drop the letters from any cells containing numbers and letters and return just the numbers.

Thanks

try

Please Login or Register  to view this content.

That works perfectly!
Thank you!