Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Don Lincoln Don Lincoln is offline
Junior Member
 
Posts: 0
Smile 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
user form - format a phone number word 2007 Dcook Microsoft Word Help 2 May 12th 10 11:38 PM
user form - format a phone number word 2007 Dcook Microsoft Word Help 0 May 12th 10 03:31 PM
Word 2007-format a text form field as a phone number Tammy Microsoft Word Help 3 December 15th 09 06:20 PM
Offcie Pro 2007 - extract phone numbers from word and text formats hbscreamer Microsoft Word Help 1 February 21st 08 03:08 PM
phone directory with addresses and phone number from existing fi. Nicky Mailmerge 1 October 11th 06 04:47 AM


All times are GMT +1. The time now is 04:39 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"