Thread: How do I remove non-numerical charaters from a string?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Steve is offline
external usenet poster
  
Posts: 1,814
Default How do I remove non-numerical charaters from a string?
I have data formatted like 038-1439-00 and I would like to remove the dashes
so that the cell reads 038143900. Is there a formula in Excel that can strip
out the dashes?
Reply With QuoteReply With Quote