Microsoft Office Forums Merging three columns of data

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-01-2012, 08:40 AM
jdjette jdjette is offline Merging three columns of data Mac OS X Merging three columns of data Office 2008 for Mac
Novice
Merging three columns of data
 
Join Date: Feb 2012
Posts: 5
jdjette is on a distinguished road
Default Merging three columns of data

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
Reply With Quote
  #2  
Old 02-01-2012, 09:39 AM
JBeaucaire JBeaucaire is offline Merging three columns of data Windows XP Merging three columns of data Office 2003
Advanced Beginner
 
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default

Column A: First Name
Column B: Last Name
Column C: Company Name

In D1 put this formula:

=A1 & " " & B1 & CHAR(10) & C1

Then format that cell to Wrap Text. Copy that down as needed.
Reply With Quote
  #3  
Old 02-02-2012, 08:52 AM
jdjette jdjette is offline Merging three columns of data Mac OS X Merging three columns of data Office 2008 for Mac
Novice
Merging three columns of data
 
Join Date: Feb 2012
Posts: 5
jdjette is on a distinguished road
Default

Thank you so much! That worked like a charm. Now if I could just get Word to cooperate.......

~janelle
Reply With Quote
  #4  
Old 02-02-2012, 10:44 AM
JBeaucaire JBeaucaire is offline Merging three columns of data Windows XP Merging three columns of data Office 2003
Advanced Beginner
 
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default

If you lay out your Label template in an Excel spreadsheet, we can add the logo you want there, then use a macro to feed your names into the template sheet, print, loop, repeat. Pretty easy, probably.
Reply With Quote
  #5  
Old 02-02-2012, 11:13 AM
jdjette jdjette is offline Merging three columns of data Mac OS X Merging three columns of data Office 2008 for Mac
Novice
Merging three columns of data
 
Join Date: Feb 2012
Posts: 5
jdjette is on a distinguished road
Default

Do you mean I could create a new sheet to add to the Elements Gallery? So I format the custom sheet to reflect the name tag template with logo embedded at the bottom of each name tag area? I need to use the Avery #5392 name tag template (6-up on a page) and ensure that our company logo stays put at the bottom of each label, centered. It does sound simple, but Word is giving me a crazy hard time making it happen smoothly.

If I can get a new sheet created to resemble my label template, can you help me out with the Macro code to use to make the information in Column D flow correctly into the template? If so...you're a GENIUS and I thank you for your time and attention!

~janelle
Reply With Quote
  #6  
Old 02-02-2012, 10:34 PM
JBeaucaire JBeaucaire is offline Merging three columns of data Windows XP Merging three columns of data Office 2003
Advanced Beginner
 
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default

I'm all for NOT reinventing wheels.... so check this out:

Avery Label Wizard - Free Software
Reply With Quote
  #7  
Old 03-02-2012, 02:27 PM
jdjette jdjette is offline Merging three columns of data Mac OS X Merging three columns of data Office 2008 for Mac
Novice
Merging three columns of data
 
Join Date: Feb 2012
Posts: 5
jdjette is on a distinguished road
Default

JBeaucaire,

Thank you a million times for the suggestions and great tips! I have just shared the Avery wizard with my co-workers and worked out the kinks in their process of printing name tags. What used to take them over 3 hours in many cases, now takes them about 20 minutes. I commend you - you are very helpful and kind! Bravo~

Janelle
Reply With Quote
  #8  
Old 03-02-2012, 04:48 PM
JBeaucaire JBeaucaire is offline Merging three columns of data Windows XP Merging three columns of data Office 2003
Advanced Beginner
 
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default

We are a village...! Cheers.
Reply With Quote
Reply

Tags
format data in cell, merge columns, merge fields

Thread Tools
Display Modes


Similar Threads
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
Merging three columns of data Cannot enter data in certain columns of tables 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


All times are GMT -7. The time now is 06:41 PM.


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