Cell Data
 

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

Cell Data
 

Try in B1: =SUBSTITUTE(A1,"-","")
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"S. Kissing" wrote:
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

Cell Data
 

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

"S. Kissing" wrote:

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