I have an excel spreadsheet that has taken ads from craigslist and broken them down into various columns: ad title, ad content, email address, city, etc....
I need a macro created that will extract a phone number from the ad content cell. The phone numbers will be in a lot of different formats. Here are some examples of the formats the phone numbers will be in:
[login to view URL]
xxxxxxxxxx (all 10 numbers in a string)
I need these numbers to be extracted out of one cell and a new spreadsheet to be created with 3 seperate cells:
Cell 1: Area code (first 3)
Cell 2: Prefix (second 3 digits)
Cell 3: Suffix (last 4 digits)
The new spreadsheet should have the following:
Cells 1-3: Phone numbers
Cell 4: Email address
Cell 5: Ad Title
Now, some of the cells with ad content will not have a phone number, so the macro will need to skip over those cells.
I have attached a sample of the original [login to view URL] document.