You could use Find/Replace for each of the 3 symbols to eliminate.

Select all of your phone numbers
From the Edit Menu, choose "Replace"
In the Find What field, enter: (
Leave the Replace With field blank
Click "Replace All"
Repeat for ) and - symbols

HTH,
Elkar


"biffula" wrote:

I have a list of thousands of phone numbers. I have been trying
various formulas to no success. My phone numbers look like this:

(123)456-7890

and I need them to look like this:

1234567890

They are in columns. Thanks.