![]() |
#1
|
|||
|
|||
![]()
Hi,
I am working on a solution to a co-worker's issue of getting names and company names from a worksheet in Excel, into Word to use in a label template. When the data gets organized in Excel, there is a column for First Name, column for Last Name, and a third column for the Company Name of the person. What I would like to do is merge the information so that the First, Last and Company Name(s) all wind up in their own cell (preferably with first and last names on one line, a paragraph return and then the company name on the second line. Is there a way to do this? If there is a Macro code to use on this issue....what is that and how do I use it? I'm not an Office pro, I'm a graphic designer. I'm pretty good at troubleshooting processes between various platforms, but I'm having trouble with this one. Help, please! Thank you~ Janelle |
Tags |
format data in cell, merge columns, merge fields |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I stack columns of data on top of each other? | Snvlsfoal | Excel | 1 | 07-29-2011 10:16 AM |
![]() |
HipHopapotamus | Word Tables | 1 | 05-02-2011 06:57 PM |
Can I do this? sorting data in seperate columns | shumonsaha | Excel | 0 | 07-04-2010 03:05 AM |
Mail Merging more than 1 line of data ?? | Keith24249 | Mail Merge | 0 | 10-16-2009 06:36 AM |
Mail merging and pulling varying data from Excel | shannag1881 | Mail Merge | 0 | 10-05-2009 08:51 AM |