Much simpler and more elegant than my example. I'll have to remember
this.

Mark Lincoln

On Jun 21, 1:12 pm, vezerid wrote:
The following formula will return text and thus preserve the 00's.

=SUBSTITUTE(A2,"-","")

HTH
Kostis Vezerides

On Jun 21, 8:31 pm, "Pat Jones" wrote:



Thanks Pete;

That works except for one thing that I didn't realize was important - many
of these numbers start with a zero (0). The find and replace got rid of the
zeros. I then formatted the cells as text, but the zeros were still gone on
some - but not all - of the results.

Any ideas how to preserve those zeros ?

Cheers;
Pat

"Pete_UK" wrote in message

ups.com...

Highlight the column and do Find & Replace (CTRL-H):

Find What: -
Replace with: (leave empty)

Click Replace All.

Note that if you have "numbers" like 0012-3456, you will lose the
leading zeros and end up with 123456.

Hope this helps.

Pete

On Jun 21, 4:39 pm, "Pat Jones" wrote:
Hi;

I have a long column of numbers that contain "-" (I call them dashes). I
need to remove the dashes from these 3000+ numbers. Is there a way to
automate this process?

Thanks;

Pat- Hide quoted text -

- Show quoted text -