Removing "-" from several fields

[Ryan]

I have a list of phone number in the following format "555-
555-555". Does anyone know of a formula I could use to
remove the "-" from the phone numbers?

Ryan

 

[Aladin Akyurek]

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

 

[Jason Morin]

One way other than a formula would be to select your
range, press Ctrl+H, type "-" (no quotes) for find what
and press enter.

HTH
Jason
Atlanta, GA