How do I extract phone numbers from various formats?

Hello Everybody,

Am not an Excel Expert, am just a regular user for everyday office use.
I seriously have a problem and am looking out for a way to get this solved.
I get spreadsheets from my office everyday, which really screws my time off. Takes hours and hours to extract these information. Initially it was ok but now I am really getting frustrated with it, Your help would be greatly appreciated.

Problem: How do I extract the Phone Numbers which are in various formats from one column to another. Just take a look at the attachment. Thanking you guys in advance, am really in hell working with these files containing more than 2000 contacts like these everyday. Please HELP!!!!

I would be really happy if someone could help me out with this, please.

welcome to the forum.

however, please do not upload a picture of what you want, some1 may just send you back a picture of the solution. rather, upload a sample workbook, showing what data you are working with, a few examples of what your expected outcome would be, and how you would arrive at that (remove any confidential info if necessary).

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.