Project Detail

Excel Macro Needed - Extract phone numbers from spreadsheet  

Excel Macro Needed - Extract phone numbers from spreadsheet is project number 539000
posted at Freelancer.com. Click here to post your own project.

 

| More
Free Trial For New Buyers
 

Status:

Selected Providers: mahfuzmurshed,
dinhtoan

Budget: $30-250

Created: 10/29/2009 at 11:45 EDT

Bid Count: 36

Average Bid:
$ 49

11/03/2009 at 11:45 EST

Project Creator: bullara23
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (1 reviews)

Bid On This Project
 

Description

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
xxx.xxx.xxxx
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 Listings.csv document.


Additional files submitted:
Listings.csv

Messages Posted:1 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

35

0 days

10-29-2009 14:04 EDT

Looking forward to working with you...

help

 

150

1 day

10-29-2009 11:53 EDT

Hi, Please view my PM for details, thanks.

help

 

38

1 day

10-29-2009 19:05 EDT

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

help

 

30

3 days

10-29-2009 15:17 EDT

can do it, please see PMB

help

 

30

0 days

10-29-2009 14:55 EDT

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

help

 

75

2 days

10-29-2009 13:29 EDT

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, MsExcel, SQL, VB.Classic, VB.Net, VBA, VBScript, and Windows programming Expert, Leader and Mentor [screenname:wsh2] at www.vbcity.com and www.experts-exchange.com. I have successfully completed quite a few GAF projects, so you can find additional references for me here: http://getafreelancer.com/users/feedback_172391.html I have 25+ years of hands-on Programming and Business Information System experience to include many data extraction applications similar to yours. I have a BS in Accounting with a Marketing Minor and graduated college with the highest of honors. I am located in Easton PA USA (halfway between Philadelphia and New York City). American English is my only language. I look forward to assisting you in achieving all of your goals in this endeavor. Respectfully, Bill.

help

 

75

1 day

10-29-2009 13:18 EDT

Hi. Please check PMB. Thanks

help

 

30

2 days

10-29-2009 15:18 EDT

Refer to PMB.

help

 

100

1 day

10-29-2009 11:57 EDT

ready to start, please check PMB more details,

help

 

30

1 day

10-29-2009 16:46 EDT

Please check PMB.

help

 

30

0 days

10-29-2009 19:51 EDT

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

help

 

40

1 day

10-29-2009 16:44 EDT

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

help

 

101

0 days

10-29-2009 14:44 EDT

Hi, please refer PM. Regards

help

 

45

3 days

10-29-2009 13:40 EDT

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

help

 

33

1 day

10-29-2009 14:49 EDT

Please check PMB for details.

help

 

55

2 days

10-29-2009 18:54 EDT

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

help

 

50

1 day

10-29-2009 13:38 EDT

Please check pm.

help

 

50

0 days

10-29-2009 12:13 EDT

Please see PM.

help

 

36

0 days

10-29-2009 16:18 EDT

(No Feedback Yet)

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

help

 

30

5 days

10-29-2009 12:30 EDT

(No Feedback Yet)

hi i have done a certified course in advance excel and i can assure you the quality of the work done just give me a chance to show my skills and ability waiting for your response please feel free to clear your doubts anytime...... thanx

help

 

30

3 days

10-29-2009 13:24 EDT

(No Feedback Yet)

Please see yoru PM.

help

 

30

5 days

10-29-2009 13:38 EDT

(No Feedback Yet)

Please see my PM.

help

 

30

1 day

10-29-2009 14:07 EDT

(No Feedback Yet)

hi i can do this work.. and payment method i prefer is by paypal..

help

 

30

1 day

10-29-2009 14:10 EDT

(No Feedback Yet)

Hi, I'm an Excel guru. I'll get it done right and quick. :)

help

 

50

2 days

10-29-2009 14:11 EDT

(No Feedback Yet)

we make an independent program for it if you want.

help

 

100

2 days

10-29-2009 14:20 EDT

(No Feedback Yet)

Hello I am very experienced with Excel macro automation and have over 3 years experience to validate me. I offer the best possible service at the best possible price. Others may under bid me but the quality will not be on par. PM or email me for more details.

help

 

50

10 days

10-29-2009 14:30 EDT

(No Feedback Yet)

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 (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 This will help you to run the application in any number of PCs and is very simple, no need to open xel sheet and run the macro...just click the button and application will do everything. Source codes will also be provided to you. Lets start the work if You feel OK.

help

 

50

2 days

10-29-2009 14:56 EDT

(No Feedback Yet)

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 numbers will be split into the requested 3 categories.

help

 

30

1 day

10-29-2009 15:03 EDT

(No Feedback Yet)

This is a simple program.

help

 

37

2 days

10-29-2009 15:46 EDT

(No Feedback Yet)

RegEx expert at your service. 1 day delivery, $37 what a bargain! 1 day delivery, 1 day for your own testing and enhancement request.

help

 

50

2 days

10-29-2009 17:04 EDT

(No Feedback Yet)

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.

help

 

80

1 day

10-29-2009 19:24 EDT

(No Feedback Yet)

I work for a company that uses excel macros on a daily basis. Although I have no feedback as of yet, it is because I am new to the site. This will be the first project I complete so please give me a chance to prove my programming strengths. I can deliver results in less than a day.

help

 

30

0 days

10-29-2009 20:20 EDT

(No Feedback Yet)

Please check PM for more details.

help

 

30

1 day

10-29-2009 20:26 EDT

(No Feedback Yet)

I have more than 10 years experience with MACRO. Hope to work with you asap.

help

 

30

2 days

10-29-2009 20:58 EDT

(No Feedback Yet)

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.

help

 

30

1 day

10-29-2009 21:07 EDT

(No Feedback Yet)

I have many years of Macro experience. I can do it.

help


    Bid on this Project