Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-04-2023, 01:39 AM
Gouldinho Gouldinho is offline Fragment address from a single cell in excel to multiple fields in word Windows 10 Fragment address from a single cell in excel to multiple fields in word Office 2021
Novice
Fragment address from a single cell in excel to multiple fields in word
 
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
  #2  
Old 01-04-2023, 01:42 AM
macropod's Avatar
macropod macropod is offline Fragment address from a single cell in excel to multiple fields in word Windows 10 Fragment address from a single cell in excel to multiple fields in word Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Gouldinho View Post
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-04-2023, 01:54 AM
Gouldinho Gouldinho is offline Fragment address from a single cell in excel to multiple fields in word Windows 10 Fragment address from a single cell in excel to multiple fields in word Office 2021
Novice
Fragment address from a single cell in excel to multiple fields in word
 
Join Date: Jan 2023
Posts: 5
Gouldinho is on a distinguished road
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fragment address from a single cell in excel to multiple fields in word 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
Fragment address from a single cell in excel to multiple fields in word How to count multiple values in a single cell, except zero? iuliandonici Excel 1 04-13-2011 09:45 PM
Fragment address from a single cell in excel to multiple fields in word Sum & difference between multiple values in a single cell iuliandonici Excel 4 04-13-2011 09:27 PM
Fragment address from a single cell in excel to multiple fields in word Copying Multiple tables from excel into a single word document dineshtgs Word Tables 1 04-07-2011 01:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:15 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft