#1   Report Post  
Posted to microsoft.public.word.docmanagement
Huber57 Huber57 is offline
external usenet poster
 
Posts: 22
Default Extract text strings

To all:

I have looked throughout the forum and cannot find the solution to my
problem.

I have a document that has text strings within single quotes (e.g. 'this is
sample text')

I need to pull all of these out and place them in another document (or
preferrably an excel spreadsheet).

If someone could point me to some VBA code, that would be much appreciated.

  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Extract text strings

If you have Word 2003 or above, you can use the "Find All" feature to do
this; see
http://sbarnhill.mvps.org/WordFAQs/S...ngSelectedText
(scroll up from that section to get the intro to Find All).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Huber57" wrote in message
...
To all:

I have looked throughout the forum and cannot find the solution to my
problem.

I have a document that has text strings within single quotes (e.g. 'this
is
sample text')

I need to pull all of these out and place them in another document (or
preferrably an excel spreadsheet).

If someone could point me to some VBA code, that would be much
appreciated.



  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Extract text strings

If you have Word 2003 or above, you can use the "Find All" feature to do
this; see
http://sbarnhill.mvps.org/WordFAQs/S...ngSelectedText
(scroll up from that section to get the intro to Find All).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Huber57" wrote in message
...
To all:

I have looked throughout the forum and cannot find the solution to my
problem.

I have a document that has text strings within single quotes (e.g. 'this
is
sample text')

I need to pull all of these out and place them in another document (or
preferrably an excel spreadsheet).

If someone could point me to some VBA code, that would be much
appreciated.



  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Pesach Shelnitz[_2_] Pesach Shelnitz[_2_] is offline
external usenet poster
 
Posts: 277
Default Extract text strings

Hi,

In addition, you will need to click More, select the Use wildcards check
box, and type '*' in the Find what box.

Important: When you are finished using wildcards, clear the Use wildcards
check box and perform another search to disable wildcards.

--
Hope this helps,
Pesach Shelnitz
My Web site: http://makeofficework.com


"Suzanne S. Barnhill" wrote:

If you have Word 2003 or above, you can use the "Find All" feature to do
this; see
http://sbarnhill.mvps.org/WordFAQs/S...ngSelectedText
(scroll up from that section to get the intro to Find All).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Huber57" wrote in message
...
To all:

I have looked throughout the forum and cannot find the solution to my
problem.

I have a document that has text strings within single quotes (e.g. 'this
is
sample text')

I need to pull all of these out and place them in another document (or
preferrably an excel spreadsheet).

If someone could point me to some VBA code, that would be much
appreciated.



.

  #5   Report Post  
Posted to microsoft.public.word.docmanagement
Pesach Shelnitz[_2_] Pesach Shelnitz[_2_] is offline
external usenet poster
 
Posts: 277
Default Extract text strings

Hi,

In addition, you will need to click More, select the Use wildcards check
box, and type '*' in the Find what box.

Important: When you are finished using wildcards, clear the Use wildcards
check box and perform another search to disable wildcards.

--
Hope this helps,
Pesach Shelnitz
My Web site: http://makeofficework.com


"Suzanne S. Barnhill" wrote:

If you have Word 2003 or above, you can use the "Find All" feature to do
this; see
http://sbarnhill.mvps.org/WordFAQs/S...ngSelectedText
(scroll up from that section to get the intro to Find All).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Huber57" wrote in message
...
To all:

I have looked throughout the forum and cannot find the solution to my
problem.

I have a document that has text strings within single quotes (e.g. 'this
is
sample text')

I need to pull all of these out and place them in another document (or
preferrably an excel spreadsheet).

If someone could point me to some VBA code, that would be much
appreciated.



.



  #6   Report Post  
Posted to microsoft.public.word.docmanagement
Huber57 Huber57 is offline
external usenet poster
 
Posts: 22
Default Extract text strings

Suzanne,

That is great. I am now struggling with the search language.

I tried '*' to get anything within quotes but I don't think it is acting as
a wildcard to return any number of characters.

how would i search for strings or differing lengths at one time?

Sincerely,

Doug

"Suzanne S. Barnhill" wrote:

If you have Word 2003 or above, you can use the "Find All" feature to do
this; see
http://sbarnhill.mvps.org/WordFAQs/S...ngSelectedText
(scroll up from that section to get the intro to Find All).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Huber57" wrote in message
...
To all:

I have looked throughout the forum and cannot find the solution to my
problem.

I have a document that has text strings within single quotes (e.g. 'this
is
sample text')

I need to pull all of these out and place them in another document (or
preferrably an excel spreadsheet).

If someone could point me to some VBA code, that would be much
appreciated.



.

  #7   Report Post  
Posted to microsoft.public.word.docmanagement
Huber57 Huber57 is offline
external usenet poster
 
Posts: 22
Default Extract text strings

Suzanne,

That is great. I am now struggling with the search language.

I tried '*' to get anything within quotes but I don't think it is acting as
a wildcard to return any number of characters.

how would i search for strings or differing lengths at one time?

Sincerely,

Doug

"Suzanne S. Barnhill" wrote:

If you have Word 2003 or above, you can use the "Find All" feature to do
this; see
http://sbarnhill.mvps.org/WordFAQs/S...ngSelectedText
(scroll up from that section to get the intro to Find All).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Huber57" wrote in message
...
To all:

I have looked throughout the forum and cannot find the solution to my
problem.

I have a document that has text strings within single quotes (e.g. 'this
is
sample text')

I need to pull all of these out and place them in another document (or
preferrably an excel spreadsheet).

If someone could point me to some VBA code, that would be much
appreciated.



.

  #8   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Extract text strings

Do you have "Use wildcards" checked?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Huber57" wrote in message
...
Suzanne,

That is great. I am now struggling with the search language.

I tried '*' to get anything within quotes but I don't think it is acting
as
a wildcard to return any number of characters.

how would i search for strings or differing lengths at one time?

Sincerely,

Doug

"Suzanne S. Barnhill" wrote:

If you have Word 2003 or above, you can use the "Find All" feature to do
this; see
http://sbarnhill.mvps.org/WordFAQs/S...ngSelectedText
(scroll up from that section to get the intro to Find All).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Huber57" wrote in message
...
To all:

I have looked throughout the forum and cannot find the solution to my
problem.

I have a document that has text strings within single quotes (e.g.
'this
is
sample text')

I need to pull all of these out and place them in another document (or
preferrably an excel spreadsheet).

If someone could point me to some VBA code, that would be much
appreciated.



.



  #9   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Extract text strings

Do you have "Use wildcards" checked?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Huber57" wrote in message
...
Suzanne,

That is great. I am now struggling with the search language.

I tried '*' to get anything within quotes but I don't think it is acting
as
a wildcard to return any number of characters.

how would i search for strings or differing lengths at one time?

Sincerely,

Doug

"Suzanne S. Barnhill" wrote:

If you have Word 2003 or above, you can use the "Find All" feature to do
this; see
http://sbarnhill.mvps.org/WordFAQs/S...ngSelectedText
(scroll up from that section to get the intro to Find All).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Huber57" wrote in message
...
To all:

I have looked throughout the forum and cannot find the solution to my
problem.

I have a document that has text strings within single quotes (e.g.
'this
is
sample text')

I need to pull all of these out and place them in another document (or
preferrably an excel spreadsheet).

If someone could point me to some VBA code, that would be much
appreciated.



.



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
Extract by text color BBDavid1 Microsoft Word Help 1 February 13th 08 06:48 PM
Automating repetitive tasks-creating text strings from excel into Jacky D. Microsoft Word Help 5 June 8th 07 06:23 PM
MAILMERGE IF condition - long text strings PromisedOyster Mailmerge 3 November 10th 06 01:18 PM
How to make overstrike through strings of text/numbers? SkidoggT Microsoft Word Help 2 September 11th 05 08:05 AM
Make Word displays strings of text, not strings of code Xero Microsoft Word Help 2 December 9th 04 11:35 AM


All times are GMT +1. The time now is 12:33 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"