Try this formula in B1
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"-",""),"(",""),")","")," ","")

And copy down

--
Regards Ron de Bruin
http://www.rondebruin.nl


"kbkst" <u18755@uwe wrote in message news:5bef1c9a443b5@uwe...
I am cutting & pasting phone numbers onto my excel spreadsheet. When they
are pasted, they look like this: (216) 433-7623. I need them to look like
this: 2164337623, which means I need to remove the ( ), the space and the
dash. It takes forever doing thousands of these. Is there a formula that
can be added to these cells to automatically delete these when I paste?

Hope someone can help...I am loosing my mind!

Thanks,
kbkst