Eliminating Dashes

[Rob]

Hello. I have column that has thousands of entries in
it. Some of the entries include dashes. How can I
eliminate the "dashes" all at once?

Thanks.

 

[Mark Graesser]

Edit>Replace. Just leave the replace with field empty.

Good Luck,
Mark Graesser
(e-mail address removed)

----- Rob wrote: -----

Hello. I have column that has thousands of entries in
it. Some of the entries include dashes. How can I
eliminate the "dashes" all at once?

Thanks.

 

[pfsardella]

See the 'Substitute' worksheet function in Excel's help.

Assuming that your entry is in Cell A1,

=SUBSTITUTE(A1, "-","")

Copy formula as needed. Then, Copy > Paste Special > Values.

HTH,
Paul