Cell Data

[S. Kissing]

I have text listed with dashes, 004-82-1000, I need to remove the dashes so
my data is a nine digit entry, 004821000. When I use replace I loose the
leading zeros...Help

 

[Max]

Try in B1: =SUBSTITUTE(A1,"-","")
Copy down

 

[Duke Carey]

In addition to Max's solution you can 1) format the cells as text, then 2) do
a search & replace, replacing the hyphens with nothing