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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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