Cleanup telephone numbers that have some text data

I have some cells which contain telephone number and some text data. They look like this.

(713) 555-4600 (Work)
(713) 555-4620 (Home)
(832) 555-4610 (John's Phone)

I need to strip out the text data and just display the phone number as follows

(713) 555-4600
(713) 555-4620
(832) 555-4610

select the column which has tel. number ->text to column->select fixed width radio button->next-> here u will see three line .just need to drag 1st line over second
then next & finish .

Originally Posted by sktneer

Assuming your telephone number is in A2, then try this....

Please Login or Register  to view this content.

Does this help?

That's perfect. Thank you!