See
http://www.ozgrid.com/VBA/ExtractNum.htm
which can handle Decimal and negative values, or not.
--
Regards
Dave Hawley
www.ozgrid.com
"Bam" wrote in message
...
Hi All,
I have a colmun of Codes, of varying lengths that contains Letters at the
end of each Code.
The letters range from 1 single letter up to a word, again of varying
lengths.
I need to strip out all alpha letters and retain only the numeric numbers.
Either a fomula or Macro.
Many Thanks,
Bam.