View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rmaloy rmaloy is offline
external usenet poster
 
Posts: 1
Default Deleting Hyphens or Dashes from multiple cells without deleting the remaining content

I have a column in excel that has a list of circuit id's. All of these
have hyphens/dashes in them and some are in different locations. (Ex.
13-44M-121-0001, 13-44M1-210-0001) Is there anyway to delete all of the
hyphens/dashes, without having to go into each cell individually? I
still need the characters to remain in order, just without the hyphens.
(Ex. 1344M1210001, 1344M12100001)

Thanks!


---
Message posted from http://www.ExcelForum.com/