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

The last argument is a pair of double quotes with no space between
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Wanna Learn" wrote in message
...
Hello
I have a column of numbers example 12-2222-02 . I need to delete the
dashes.
the number should read 12222202 What is the fastest way to do this
thanks