Em Andamento

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.

Habilidades: Programação C, Excel, Visual Basic, Captura de dados na web, Área de trabalho do Windows

Ver mais: 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

Acerca do Empregador:
( 0 comentários ) chciago, United States

ID do Projeto: #539000

Premiar a:

dinhtoan

ready to start, please check PMB more details,

$100 USD em 1 dia
(0 Avaliações)
0.0
mahfuzmurshed

Please see PM.

$50 USD em 0 dias
(71 Avaliações)
4.6

35 freelancers estão ofertando em média $49 para este trabalho

xamdam91

Looking forward to working with you...

$35 USD in 0 dias
(68 Comentários)
6.5
guoxinliu917

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

$30 USD in 0 dias
(31 Comentários)
6.0
Kryptora

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

$45 USD in 3 dias
(48 Comentários)
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 Mais

$75 USD in 2 dias
(26 Comentários)
5.5
lucky2gaf

Hi, Please view my PM for details, thanks.

$150 USD em 1 dia
(57 Comentários)
5.6
agihcam

Please check PMB.

$30 USD em 1 dia
(40 Comentários)
5.2
rajanlengde

can do it, please see PMB

$30 USD in 3 dias
(27 Comentários)
5.1
DrTech76

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

$30 USD in 0 dias
(39 Comentários)
5.0
dev3dworx

Please check PMB for details.

$33 USD em 1 dia
(19 Comentários)
4.7
pyazlm

Refer to PMB.

$30 USD in 2 dias
(33 Comentários)
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 em 1 dia
(18 Comentários)
4.3
wintergoes

Please check pm.

$50 USD em 1 dia
(22 Comentários)
4.2
oFAZo

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

$40 USD em 1 dia
(15 Comentários)
4.1
SSYES

Hi, please refer PM. Regards

$101 USD in 0 dias
(2 Comentários)
4.0
ruimaxwell

Hi. Please check PMB. Thanks

$75 USD em 1 dia
(10 Comentários)
3.6
bob12603

Please see my PM.

$30 USD in 5 dias
(3 Comentários)
2.8
sameersac

Please see yoru PM.

$30 USD in 3 dias
(1 Comentário)
1.0
riff79

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

$55 USD in 2 dias
(1 Comentário)
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 dias
(0 Comentários)
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 dias
(0 Comentários)
0.0