Extract text strings

[Huber57]

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.

 

[Suzanne S. Barnhill]

If you have Word 2003 or above, you can use the "Find All" feature to do
this; see
http://sbarnhill.mvps.org/WordFAQs/SpecialFind.htm#CopyingSelectedText
(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

 

[Pesach Shelnitz]

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.

 

[Huber57]

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]

Do you have "Use wildcards" checked?

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