View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hardeep kanwar[_2_] Hardeep kanwar[_2_] is offline
external usenet poster
 
Posts: 14
Default Remove all Characters Remains only Numeric Data

Hello Experts

I have Mobile No. in Column A1:A300000, But the Problem is that in Many Cell
there are Unused and Special Character like Dash,comma,Slash, Doted Line.
Slash Lines in Some Cell i have Mobile No. like A9810332270 or 9810332270F

How can i delete these Data and Remains only Numeric Data

Thanks in Advance

Hardeep Kanwar