View Single Post
 
Old 11-12-2017, 06:52 PM
Bugfinder Bugfinder is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Nov 2017
Posts: 6
Bugfinder is on a distinguished road
Default

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 )
Reply With Quote