Excel - Remove "-" Leave the Rest?

[csmith10]

I have numbers similar to what is listed below that are being downloaded into Excel. I need to take the number and remove the "-" from it, but leave the rest of the number in the same cell.


Example:

These are some of the numbers being downloaded and imported into Excel:

A8001-O-C
A8002-O-C
A8003-O-C


I need them to look like this:

A8001OC
A8002OC
A8003OC


There are about 200 of them total, and will be more soon. I don't want to go through each one individaully every time I do this. Is it possible to get rid of the "-" and leave the raw numbers in the same cell?

 

[DaleWatson123321]

The easiest option is to do a search/replace.

Simply:

1) Highlight the range

2) Hold down the <Control> key and hit &quot;H&quot;

3) Under &quot;Find what&quot;, type the hyphen character: &quot;-&quot;

4) Leave &quot;Replace with&quot; empty.

5) Click &quot;Replace all&quot;

Hope this helps. Please advise as to how you make out.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[carrr]

Highlight the column, use Edit, Replace, replace - with a blank cell and they're gone.

 

[csmith10]

Thanks...that worked perfect! I'm forgetting the basics this week it seems.

 

[carrr]

Sorry Dale, didn't mean to bump heads, didn't see your post 'til too late.