Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Extract phone number from word file
Hello
I’m looking for a word macro that will extract numbers from a word file Its has bunch of numbers. The format of those numbers are ###+###-####, so it’s a 10 digit format after first 3 digits there is a plus sign and then after 3 digits there is a minus sign and then the last 4 digits. What the macro should do is find the phone number and extract that into a new word window and then if the there is a DUPLICATE OF THAT NUMBER then the word should SKIP THAT NUMBER. and then search and extract the next number since the file has lots of duplcate number and i only need unique numbers. Below is the sample data, data data data data data data data data data data data data data data data 951+907-3887 data data data data data data data data data data data data data data data 951+907-3887 data data data data data data data data data data data data data data data 951+907-3887 data data data data data data data data data data data data data data data 916+555-1212 data data data data data data data data data data data data data data data 916+555-1212 data data data data data data data data data data data data data data data Thanks. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
user form - format a phone number word 2007 | Microsoft Word Help | |||
user form - format a phone number word 2007 | Microsoft Word Help | |||
Word 2007-format a text form field as a phone number | Microsoft Word Help | |||
Offcie Pro 2007 - extract phone numbers from word and text formats | Microsoft Word Help | |||
phone directory with addresses and phone number from existing fi. | Mailmerge |