View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bam Bam is offline
external usenet poster
 
Posts: 48
Default Remove Text From AlphaNumeric

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.