Delete part of number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!

I hope somebody can help me in this matter. I have this number
49-02505-28162-4 in about 1000 cells in Excel and would like to change all to
4902505281624. Does anyone know a simple way to do this to thousands?
 
Thank you very much, but how do I do this exactly. See, I'm quite new to this.
Thakns in advance.
 
WOW! I Figured it out all by myself! ;-)
I simply used the replace-function i the Edit-menu. Couldn't be easier.
 
Great! As an alternate approach, see Help for the SUBSTITUTE worksheet
function.

Jerry
 
Back
Top