=MID(A1,2,3)&MID(A1,6,3)&RIGHT(A1,4)

This should do the trick (if your data is in cell A1)

"Nick C" wrote:

Hello,
I am trying to extract a long list of phone numbers from text
i.e.:
i am trying to get 9998887777 out of (999)888-7777
(these cells are not formatted, the parenthesis and dashes were manually
typed in)
Any good ideas?