View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bijan bijan is offline
external usenet poster
 
Posts: 44
Default convert to Numer

Hi all,
I need a function or sample vba code to convert data with character and
spetial character in column A To Culumn B with just Number:

Column A Column B
-------------------------- --------------------------
ZB0056/87998234/BCS 005687998234
64544/64646646BCS 6454464646646
LM01/636336321 01636336321
83333/77/393939 8333377393939

Thanks in advanced
Bijan