Thread: Converting names/addresses in Word to an Excel File
View Single Post
 
Old 02-04-2021, 01:10 PM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
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
Since the OP elected not to respond to post #3, which was almost 6 months ago, it is reasonable to assume it's no longer a pressing issue.

Also, it's all very well to say "arrange the entries so that each address is separated by a delimiting character", but simply replacing line breaks with tabs or semi-colons won't ensure the data are properly restructured for a mailmerge. The single record depicted by the OP shows an addressee with two 'name' lines and four 'address' lines, plus and empty line between the last two 'address' lines. If the next record has one 'name' line and four 'address' lines, your approach will result in name & address data appearing in the same column and none of 'address' lines aligning. It gets even worse if there are five 'address' lines in some records.

Finally, if tabs are used for the record separators, these is no need for your convoluted steps 2 - 7; the data can simply be copied and pasted into Excel from Word.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote