The trade customer enters in names and address of his ordering customers in a single line in Excel. We then copy and paste this info. into Word to allow a printed address label. I can do a special paste to keep the font formatting the same (Only just worked that out!) but it would be great if it split the address down into the complete format, at the moment it just spills over 3 lines.
I've thought of many different ways to do this but nothing quite works. I'm thinking it would be better if my trade customer entered the name and address into separate fields, in essence a database. This may then make it easier to export and keep in the right format. E.g. Name, House No./Road, Town, County, Postcode. I've started reading about Pivot Tables and wonder if this is the key. I've also thought about using a database rather than Excel.
It's really just an exercise on saving time and if I'm honest it's a bit of an ongoing challenge.
Hopefully I'm missing something obvious, maybe I'm over-complicating something that works (kind of) OK
