Eliminating the dashes

D

Dashman

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

T. Valko

Try this:

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

FSt1

hi
have you tried find and replace yet.

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

click replace all

Regards
FSt1
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top