Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-12-2017, 05:35 PM
macropod's Avatar
macropod macropod 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 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,518
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #2  
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
Reply



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 03:08 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