Reply
 
Thread Tools Display Modes
  #1   Report Post  
jondaly jondaly is offline
Junior Member
 
Posts: 0
Default

Quote:
Originally Posted by Lisa Wilke-Thissen View Post
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 showbox 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]
Choose the "Find" command to select all numbers then copy and paste them into another document
Reply
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 02:48 AM.

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"