Fragment address from a single cell in excel to multiple fields in word

macropod · #2 01-04-2023, 01:42 AM

Quote:

Originally Posted by Gouldinho

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Merging multiple excel records in to a single word doc?	dns_to	Mail Merge	1	10-20-2017 01:22 PM
Exporting multiple data sets from a single Word Form into Excel	Tom Saylor	Word VBA	6	09-11-2016 05:22 AM
How to count multiple values in a single cell, except zero?	iuliandonici	Excel	1	04-13-2011 09:45 PM
Sum & difference between multiple values in a single cell	iuliandonici	Excel	4	04-13-2011 09:27 PM
Copying Multiple tables from excel into a single word document	dineshtgs	Word Tables	1	04-07-2011 01:27 AM