You could use a nested SUBSTITUTE formula or use edit/replace, or a macro
to do it for you.

Sub fixphonenumbers()
With Range("e1:e10")
.Replace "(", ""
.Replace ")", ""
.Replace " ", ""
.Replace "-", ""
End With
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bayou Johnny" wrote in message
...
I have a data export that lists telephone number in a (xxx) xxx-xxxx format
that I need to change to a number format without spaces or commas. Anyone
know of a formula to apply to a column of text numbers to make such a
conversion within a spreadsheet?