Replace dashes
=SUBSTITUTE(A1,"-","")
Dave
--
Brevity is the soul of wit.
"Wanna Learn" wrote:
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
|