Thread: removing dashes from numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default removing dashes from numbers
Look at EDIT=Replace.

"Pat Jones" wrote:

Hi;

I have a long column of numbers that contain "-" (I call them dashes). I
need to remove the dashes from these 3000+ numbers. Is there a way to
automate this process?

Thanks;

Pat



Reply With QuoteReply With Quote