Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 11-11-2017, 11:14 PM
Guessed's Avatar
Guessed Guessed is offline I have a very specific need but don't know how to do it... Windows 10 I have a very specific need but don't know how to do it... Office 2013
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,158
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

If your blocks of addresses always have the same number of paragraphs then you could select all and convert to table choosing to separate text at paragraph marks and specify 7 columns.

If there is inconsistency, you could firstly find replace all paragraph marks to tabs, then double tabs to a paragraph mark. Then convert that to a table using tabs as the separator. You will need to fix the outliers (if an address block has other than 6 paragraphs) but that may be a simple-ish task.

Another alternative is to simply use each address block as a single field by replacing all paragraph marks with a soft return and then replacing a pair of soft returns with a paragraph mark. Then convert that to a table with one column using paragraph marks as the separator.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
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 08:19 AM.


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