View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
babs babs is offline
external usenet poster
 
Posts: 38
Default How can I delete a space/character from a number of fields?

I have a column that has hyphenated numbers (XX-XX-XX-XXX-XXXX) and I need to
get rid of the hyphens. They are all in the same format so I think if I
could write code to del the 3rd, 6th, 9th, etc characters from a cell, it
would work. I just can't seem to figure the code out. or is there an easier
way?
Thx.