![]() |
|
|
|
#1
|
||||
|
||||
|
You could do a simple Find/Replace, where:
Find = ^w Replace = ^32 at any time in the process. I'd be inclined to do it first, before setting the wildcards option, but it could even be done after the table has been created and after turning off the wildcards option.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
#2
|
|||
|
|||
|
That helped, but what was causing the merging problem is some of the empty lines separating each adressee aren't actually empty. About 450 of these lines contained 1 or more spaces. After applying your last command, it left them with 1 space, which still caused merging of addresses into a single cell. What's needed in this case is to make the separating blank line with 1 space into an actual blank line with no single space. Without wildcards, I did this:
Find = ^p ^p Replace = ^p^p And that did the trick! Everything worked as intended. Mr. Edstein, you are my new hero. That was my 47th b-day present (it's still Nov. 12 here in Brazil )
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Insert specific picture and add specific Text to it | Syasthe | Word VBA | 1 | 11-02-2017 02:08 AM |
| Have a very specific requirement | ggoffice000 | Excel Programming | 2 | 02-03-2017 03:47 PM |
| Print attachment when it arrive in specific folder with specific subject | visha_1984 | Outlook | 1 | 01-30-2013 10:42 AM |
Specific Hyperlink
|
dextrousdave | Word | 1 | 01-16-2012 09:10 PM |
Looking for a specific spreadsheet
|
DivideByZer0 | Excel | 3 | 11-10-2009 05:58 PM |