I have a 500+ cell column with 13 digit numbers that look like this.
18-118-22-33-0011 I would like to remove all of the dashes from every cell
in the column but I can't figure out how.

Edit Replace

findwhat -
replace with nothing
--
Gary''s Student - gsnu200765


"Tommy Kramer 9" wrote:

I have a 500+ cell column with 13 digit numbers that look like this.
18-118-22-33-0011 I would like to remove all of the dashes from every cell
in the column but I can't figure out how.

Try

Edie|replace

enter - and whatever you want to replace it with, leave blank for nothing

Mike

"Tommy Kramer 9" wrote:

I have a 500+ cell column with 13 digit numbers that look like this.
18-118-22-33-0011 I would like to remove all of the dashes from every cell
in the column but I can't figure out how.

put your cursor on the title bar for the column ie: C
editreplace - with nothing voila

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tommy Kramer 9" <Tommy Kramer wrote in message
...
I have a 500+ cell column with 13 digit numbers that look like this.
18-118-22-33-0011 I would like to remove all of the dashes from every
cell
in the column but I can't figure out how.

Thanks guys! It worked but it left me with (<=99999) at the beginning of
each cell. Now what?

What do you want to do with the (<=99999)? Then we can answer your "Now
what" question.

Regads,
Fred.

"Tommy Kramer 9" wrote in message
...
Thanks guys! It worked but it left me with (<=99999) at the beginning of
each cell. Now what?

I think OP is wondering how it got there as much as how to deal with it.

I would also like to know.

(<=99999) was not part of the original data.


Gord Dibben MS Excel MVP

On Wed, 16 Jan 2008 10:57:54 -0600, "Fred Smith" wrote:

What do you want to do with the (<=99999)? Then we can answer your "Now
what" question.

Regads,
Fred.

"Tommy Kramer 9" wrote in message
...
Thanks guys! It worked but it left me with (<=99999) at the beginning of
each cell. Now what?

=substitute(A2,"-","") and copy down.
--
David Biddulph

"Tommy Kramer 9" <Tommy Kramer wrote in message
...
I have a 500+ cell column with 13 digit numbers that look like this.
18-118-22-33-0011 I would like to remove all of the dashes from every
cell
in the column but I can't figure out how.