View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
zyus zyus is offline
external usenet poster
 
Posts: 4
Default Problem With Text & number format

I hv this sample data in excel

019-1234567
019 1234567
019#1234567
%0191234567

My question

1) How to delete spacing, dashes, character etc leaving the number only..in
my above sample the clean data that i want to get is 0191234567

2) I tried to use replace function (to delete dash,space etc) but the
leading 0 will not be displayed.

What will be the best approach?

Thanks