View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sherees Sherees is offline
external usenet poster
 
Posts: 43
Default How to arrange number?

Hi
I have a column of around 2000 customer mobile numbers, the numbers are
having space in between nad some numbers entered with two zero in the front.
How can i arrange all the numbers without zero in front and without any space
in between? please guide me with the easiest method

Thank u
--
Life isa journey not a destination