Thread: Cell Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
S. Kissing S. Kissing is offline
external usenet poster
 
Posts: 11
Default 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