Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Extract phone number from word file
Hi,
I 'm looking for a word macro that will extract numbers from a word file which version of Word? The format of those numbers are ###+###-####, No macro, but you can choose the "Find" command to select all those numbers. And then copy and paste them into another document (I would prefer an Excel sheet): 1. Ctrl + H | Find | More 2. Find what: ^#^#^#+^#^#^#-^#^#^#^# 3. Find in: Main document All instances will be selected. So you can copy/paste them at once. In Excel 2010 you can easily remove duplicates: On the Data tab, in the Data Tools group, click Remove Duplicates. -- Cheers Lisa [MS MVP Word] |
#2
|
|||
|
|||
Quote:
|
Reply |
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 |