View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Syed Rizvi Syed Rizvi is offline
external usenet poster
 
Posts: 13
Default Removing text from Alphanumeric values

Hi
I have a column containing alphanumeric values e.g.
HG06100
H134679
HC134679
HG05534
A434340
I need a formula or macro help to remove all the text values in the cell and
leave all the numbers behind including zero. Could someone please help, thanks

Syed