Remove Text From AlphaNumeric
=LOOKUP(99^99,--("0"&MID(A1,1,ROW($1:$10000))))
--
Jacob (MVP - Excel)
"Bam" wrote:
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.
|