Thread: [Solved] Fragment address from a single cell in excel to multiple fields in word
View Single Post
 
Old 01-04-2023, 01:42 AM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,382
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
Quote:
Originally Posted by Gouldinho View Post
I have an issue where I'm pulling my clients' data from an external system to excel and it populates the entire address into one single cell.
...
I need to break this down into separate fields 'address 1, 2 & 3' and 'post code'. The only way I can find to make this work is by manually separating the addresses in Excel from the single cell into 4, which is a very slow and manual process.
Have you tried using Excel's text-to-columns tool, using the commas as the field separators?

Mailmerges cannot parse address data that have been combined in a single field in the data source.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote