Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #10  
Old 11-12-2017, 06:52 PM
Bugfinder Bugfinder is offline I have a very specific need but don't know how to do it... Windows 7 64bit I have a very specific need but don't know how to do it... Office 2016
Novice
I have a very specific need but don't know how to do it...
 
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
 



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
I have a very specific need but don't know how to do it... Specific Hyperlink dextrousdave Word 1 01-16-2012 09:10 PM
I have a very specific need but don't know how to do it... Looking for a specific spreadsheet DivideByZer0 Excel 3 11-10-2009 05:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:00 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft