View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CompuSoft CompuSoft is offline
external usenet poster
 
Posts: 5
Default remove hyphens from a list of part numbers

I have a column containng 1000 part numbers. Each part number contains a
hyphen (example 0012-3322). Is there a formula or rule for removing the
hyphen from all of the part numbers?