How can I delete a space/character from a number of fields?
Why not just select the all the cells and use Excel's Edit/Replace to
replace the hyphens with the empty string (put a hyphen in the "Find what"
field and leave the "Replace with" field empty)?
--
Rick (MVP - Excel)
"BABs" wrote in message
...
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.
|