Eliminating Dashes

R

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

Mark Graesser

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

Good Luck,
Mark Graesser
[email protected]

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

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
 
Top