#1
|
|||
|
|||
Fragment address from a single cell in excel to multiple fields in word
Hi all, 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. Obviously when I'm mail merging the client data to Word, 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. Does anyone know of a way I can ask Word to fragment the address as part of the MM - perhaps an instruction to use the next field after every comma - or have any other solution to the issue I've described? Any help would be massively appreciated! |
#2
|
||||
|
||||
Quote:
Mailmerges cannot parse address data that have been combined in a single field in the data source.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Ah no I had not. I've not used this tool before so will do some learning and try that. It sounds as though it could be exactly the solution I seek! Thank you
|
|
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 |