Cell Data

S

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
 
D

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
 
Top