View Single Post
 
Old 11-11-2017, 11:14 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 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