Home |
Search |
Today's Posts |
#1
|
|||
|
|||
trying to automate a correction
Hi All,
I've been given 7 Word files that contain about 320 pages of address labels (formatted as Avery 5162). Unfortunately, a flaw in the database that generated the files failed to insert a space in the postal code (eg L7P3C6 instead of L7P 3C6). Is there any way to have the program insert a space in all 4400+ cells? It would be in the same position in every cell (three characters in from the end). Any advice is greatly appreciated. Regards, Karen in Keswick -- n/a |
#2
|
|||
|
|||
trying to automate a correction
Assuming that the format of the postal code is consistent
(letter-digit-letter-digit-letter-digit), it should be possible to do this using wildcards: 1. Press Ctrl+H to open the Find and Replace dialog. 2. Click More to expand the dialog. 3. Check the box for "Use wildcards." 4. In the "Find what" box, type: ([A-Z][0-9][A-Z])([0-9][A-Z][0-9]) 5. In the "Replace with" box, type: \1 \2 The search string [A-Z] will find any single capital letter. [0-9] will find any digit. The parentheses group these characters into two groups, which can then be reproduced using the \1 and \2 with a space between them. For more on using wildcards, see http://word.mvps.org/FAQs/General/UsingWildcards.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "KarenRC" wrote in message ... Hi All, I've been given 7 Word files that contain about 320 pages of address labels (formatted as Avery 5162). Unfortunately, a flaw in the database that generated the files failed to insert a space in the postal code (eg L7P3C6 instead of L7P 3C6). Is there any way to have the program insert a space in all 4400+ cells? It would be in the same position in every cell (three characters in from the end). Any advice is greatly appreciated. Regards, Karen in Keswick -- n/a |
#3
|
|||
|
|||
trying to automate a correction
Worked like a charm...thank you!
Karen ) -- "Suzanne S. Barnhill" wrote: Assuming that the format of the postal code is consistent (letter-digit-letter-digit-letter-digit), it should be possible to do this using wildcards: 1. Press Ctrl+H to open the Find and Replace dialog. 2. Click More to expand the dialog. 3. Check the box for "Use wildcards." 4. In the "Find what" box, type: ([A-Z][0-9][A-Z])([0-9][A-Z][0-9]) 5. In the "Replace with" box, type: \1 \2 The search string [A-Z] will find any single capital letter. [0-9] will find any digit. The parentheses group these characters into two groups, which can then be reproduced using the \1 and \2 with a space between them. For more on using wildcards, see http://word.mvps.org/FAQs/General/UsingWildcards.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "KarenRC" wrote in message ... Hi All, I've been given 7 Word files that contain about 320 pages of address labels (formatted as Avery 5162). Unfortunately, a flaw in the database that generated the files failed to insert a space in the postal code (eg L7P3C6 instead of L7P 3C6). Is there any way to have the program insert a space in all 4400+ cells? It would be in the same position in every cell (three characters in from the end). Any advice is greatly appreciated. Regards, Karen in Keswick -- n/a |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to automate an RFT document to print twice | Microsoft Word Help | |||
How do I automate repetitive entries in a template? | Microsoft Word Help | |||
automate customized footers | Page Layout | |||
how to delete the disabled auto correction | Microsoft Word Help | |||
if I try to backspace to make a correction, letters are being cut | Microsoft Word Help |