convert phone number
Glad to help.
Fred
"andrewm" wrote in message
...
Thank you Fred !
"Fred Smith" wrote:
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
|