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

[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.

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

See more: excel macro extract phone number, excel macro phone number extract, extract phone number excel spreadsheet, string prefix, prefix string, prefix of a string, formats in excel, extract number from string, extract phone numbers spreadsheet, macro extract email excel, excel extract area code phone number, macro extract number email, excel extract phone, extract numbers phone number excel, phone ad, new excel, csv spreadsheet, skip , macro, macro excel, macro + excel, i phone 6, Extract, extract phone number, extract email

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
(58 Reviews)
4.5

34 freelancers are bidding on average $48 for this job

guoxinliu917

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

$30 USD in 0 days
(61 Reviews)
7.0
xamdam91

Looking forward to working with you...

$35 USD in 0 days
(71 Reviews)
6.5
MuhrizRashid

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

$45 USD in 3 days
(55 Reviews)
5.8
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
(30 Reviews)
5.2
lucky2gaf

Hi, Please view my PM for details, thanks.

$150 USD in 1 day
(60 Reviews)
5.6
dev3dworx

Please check PMB for details.

$33 USD in 1 day
(21 Reviews)
4.8
wintergoes

Please check pm.

$50 USD in 1 day
(21 Reviews)
4.2
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
(19 Reviews)
4.3
oFAZo

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

$40 USD in 1 day
(17 Reviews)
4.4
pyazlm

Refer to PMB.

$30 USD in 2 days
(33 Reviews)
4.5
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
(14 Reviews)
3.9
bob12603

Please see my PM.

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

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

$55 USD in 2 days
(2 Reviews)
1.9
sameersac

Please see yoru PM.

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

I Could do this job and I'm ready to complete Best Regards Eng. Zeus Paez

$36 USD in 0 days
(0 Reviews)
0.0
vipulchawla

We will be extracting the phone number based on the provided formats from the ad content(description) cell. The extracted phone number will be put into a new worksheet or a new excel(as requested). The extracted phone More

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

This is a simple program.

$30 USD in 1 day
(0 Reviews)
0.0
embicore

I can give You a VB .NET based application software in which You can upload your spread sheet and with a button click you can get a new spreadsheet with 3 seperate cells: Cell 1: Area code (first 3) Cell 2: Prefix ( More

$50 USD in 10 days
(0 Reviews)
0.0