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]
|