View Single Post
 
Old 01-04-2023, 01:39 AM
Gouldinho Gouldinho is offline Windows 10 Office 2021
Novice
 
Join Date: Jan 2023
Posts: 5
Gouldinho is on a distinguished road
Default 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!
Reply With Quote