use =SUBSTITUTE(A1,"-","") or find and replace - with ""


"TJMAURO" wrote in message
...
I am trying to change data listed in a phone number style of 555-555-5555.
I
need to eliminate the "-" so that the cells look like this: 5555555555.
Thanks!