In cell A1
1123-456-7890

In cell B1 enter formula
=--SUBSTITUTE(A1,"-",)

If this post helps click Yes
---------------
Jacob Skaria


"Rusty" wrote:

I have a string imported from a ".csv file (phone number) as follows. "=1
123-456-7890).

I need to end up with a string formated as a # as followes (11234567890).
Can someone help this old man with a fancy hi-tech way of doen this. :-(

thanks
--
rustyrunrite