You do something like this:
="1"&substitute(substitute(a1,"(",""),")","")

Regards,
Fred

"andrewm" wrote in message
...
I need to add the US prefix to a list of cellphone numbers and delete the
parentheses . How do i do that in batch ?

ex : i need to go from

(xxx)xxx-xxxx to 1xxx-xxxx