Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract by text color | Microsoft Word Help | |||
Automating repetitive tasks-creating text strings from excel into | Microsoft Word Help | |||
MAILMERGE IF condition - long text strings | Mailmerge | |||
How to make overstrike through strings of text/numbers? | Microsoft Word Help | |||
Make Word displays strings of text, not strings of code | Microsoft Word Help |