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!
|