In Progress

Excel Macro Needed - Extract phone numbers from spreadsheet

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:

xxx-xxx-xxxx

(xxx)xxx xxxx

1-xxx-xxx-xxxx

1(xxx)xxx-xxxx

[url removed, login to view]

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 [url removed, login to view] document.

Skills: C Programming, Excel, Visual Basic, Web Scraping, Windows Desktop

See more: string prefix, prefix string, formats excel, extract number string, extract phone numbers spreadsheet, macro extract email excel, macro extract number email, excel extract phone, phone ad, new excel, csv spreadsheet, skip , macro, macro excel, phone, extract, extract phone number, extract email, cells, spreadsheet csv, excel macro csv, seperate cell, sample visual basic excel, excel cell, macro spreadsheet

About the Employer:
( 0 reviews ) chciago, United States

Project ID: #539000

Awarded to:

dinhtoan

ready to start, please check PMB more details,

$100 USD in 1 day
(0 Reviews)
0.0
mahfuzmurshed

Please see PM.

$50 USD in 0 days
(71 Reviews)
4.6

35 freelancers are bidding on average $49 for this job

xamdam91

Looking forward to working with you...

$35 USD in 0 days
(68 Reviews)
6.5
guoxinliu917

Hello, I can do it for you. Please check my PMB. Thanks.

$30 USD in 0 days
(31 Reviews)
6.0
Kryptora

Hello, I am a VBA programmer. Please see your private PM for more details. Thanks.

$45 USD in 3 days
(48 Reviews)
5.7
wsh2

Greetings Illinois from Pennsylvania.. The macro you request requires some rather advanced programming techiques.. however.. the results should be very accurate. Hello my name is Bill.. I am a MsAccess, MsExc More

$75 USD in 2 days
(26 Reviews)
5.5
lucky2gaf

Hi, Please view my PM for details, thanks.

$150 USD in 1 day
(57 Reviews)
5.6
agihcam

Please check PMB.

$30 USD in 1 day
(40 Reviews)
5.2
rajanlengde

can do it, please see PMB

$30 USD in 3 days
(27 Reviews)
5.1
DrTech76

Hi, lets have a talk. Shall we? Thank you. Regards, DrTech76

$30 USD in 0 days
(39 Reviews)
5.0
dev3dworx

Please check PMB for details.

$33 USD in 1 day
(19 Reviews)
4.7
pyazlm

Refer to PMB.

$30 USD in 2 days
(33 Reviews)
4.5
johnsinit

Dear Bullara! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.

$38 USD in 1 day
(18 Reviews)
4.3
wintergoes

Please check pm.

$50 USD in 1 day
(22 Reviews)
4.2
oFAZo

Exceptional quality & Quick work. Please refer to Profile & PMB for details. Thanks FAZ

$40 USD in 1 day
(15 Reviews)
4.1
SSYES

Hi, please refer PM. Regards

$101 USD in 0 days
(2 Reviews)
4.0
ruimaxwell

Hi. Please check PMB. Thanks

$75 USD in 1 day
(10 Reviews)
3.6
bob12603

Please see my PM.

$30 USD in 5 days
(3 Reviews)
2.8
sameersac

Please see yoru PM.

$30 USD in 3 days
(1 Review)
1.0
riff79

It's a simple programming. Ready to work. Riff

$55 USD in 2 days
(1 Review)
1.0
marcelpower

I had seen your information file in .csv format i think, i it more explicit, this job could be done if you choose me as fastest as possible thanks.

$50 USD in 2 days
(0 Reviews)
0.0
PG23

I believe all you want is trisect phone numbers into 3 columns and also include emailid and other cells as need. Could you provide me with how much data you have to work on.

$30 USD in 2 days
(0 Reviews)
0.0