Try this:

Select the range of cells that contain the part numbers
Goto the menu EditReplace
Find what: enter a dash -
Replace with: nothing, leave this blank
Replace All

--
Biff
Microsoft Excel MVP


"Dashman" wrote in message
...
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.