Delete characters

[alex]

I want to be able to remove dashes from a coulmn in
excel..for example in coulmn B i have 3992393-8484-33..and
want to just show numbers no dashes..Thanks

 

[Frank Kabel]

Hi
see your other posts

 

[Guest]

Hi,

=SUBSTITUTE(B1,"-","")

jeff