Assuming data as posted is representative and is running in A1 down,
perhaps this might suffice:

In B1, copied down:
="1"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A 1,"-",""),"
",""),")",""),"(","")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Kelley" wrote:
I have a "list of fax #s in xl that I am tyring to send as a broadcast fax.
The service I have requires that the fax number be in a format with no
characters other than the numbers. For example, (912) 678-8344 must be
changed to 19126788344. Not characters other than numbers and no spaces.
Can anyone tell me a way to do this without reinventing the computer?