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.

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.

hi
have you tried find and replace yet.

Find what: - (dash)
Replace with: (leave blank)

click replace all

Regards
FSt1

"Dashman" wrote:

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.

Just select the column and do a Replace replacing - with nothing.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"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.