Delete part of number

S

Stefan

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?
 
S

Stefan

Thank you very much, but how do I do this exactly. See, I'm quite new to this.
Thakns in advance.
 
S

Stefan

WOW! I Figured it out all by myself! ;-)
I simply used the replace-function i the Edit-menu. Couldn't be easier.
 
J

Jerry W. Lewis

Great! As an alternate approach, see Help for the SUBSTITUTE worksheet
function.

Jerry
 
Top