I have a column where the telephone numbers were entered with brackets and a dash
ie (902) 555-1234
The column is in Text format.
I need a macro that will strip away the brackets and dashes and leave the number only for the entire column (over 3500 rows).
ie (902) 555-1234 to 9025551234
Any help is greatly appreciated.
Thanks.
ambra19
ie (902) 555-1234
The column is in Text format.
I need a macro that will strip away the brackets and dashes and leave the number only for the entire column (over 3500 rows).
ie (902) 555-1234 to 9025551234
Any help is greatly appreciated.
Thanks.
ambra19