![]() |
#1
|
|||
|
|||
![]() 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 | Thread Starter | Forum | Replies | Last Post |
![]() |
designer | PowerPoint | 1 | 10-14-2011 08:00 AM |
![]() |
Mark Micallef | Outlook | 1 | 08-04-2010 02:38 PM |
Can I Extract a Page from Word and Make a New DOCX File? | tatihulot | Word | 1 | 06-20-2010 11:38 PM |
in WORD, how do i type a 9-digit phone number "xxxxxxxxx" and have it automatically.. | jay8962 | Word | 0 | 04-08-2010 11:08 AM |
automatically extract footnotes into new file and apply character format to footnote | hrdwa | Word | 0 | 02-27-2010 03:16 AM |