I have a column of part numbers that have dashes in them, such as 101-500 and
I want an easy way to eliminate the dash and keep the remaoning value without
edit easch individual cell ie. F2 backspace and then delete the dash. I have
tried doing a macro but I am not familiar with how to do them.