Eliminating Dashes

  • Thread starter Thread starter Rob
  • Start date Start date
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.
 
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.
 
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
 
Back
Top