On Sat, 12 Apr 2008 12:00:19 -0500, "Beth Melton"
wrote:
What you want to do can be accomplished in Word but it would be faster to
use Excel for this (that's what I'd do, anyway):
- Copy/paste the Word table to Excel
- Add a formula to the right of the table to concatenate what you want to
see such as: =E2 & " " & F2
- Select the cell containing the formula, place your mouse pointer on the
lower right corner of the cell pointer (the mouse pointer will look like a
plus sign) and double-click to fill the formula down the table
- Select the column containing the formula and copy it
- Use Paste Special and paste the data as Values (Edit/Paste Special or
click the arrow below Paste on the Ribbon)
- Delete the columns you no longer want
- Copy/paste the table back to Word
Cool suggestion. I've been wanting to hone my Excel skills anyway.
Just out of curiosity, what sort of contortions would I have to go
through to do it in Word?
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs
Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/tr...295841033.aspx
"Three Lefts" wrote in message
news
Is there a way to merge 2 columns of a table into one with the text in
each concatenated.
Here is a sample of the table as it is now:
Date Time Start End ID Comments
04/01/08 06:15 10 35 (W) First run of day
04/01/08 10:22 12 48 (10) Just before a break
04/02/08 17:02 9 31 (W) Two hours late
This is how I'd like the new table to look:
Date Time Start End Comments
04/01/08 06:15 10 35 (W) First run of day
04/01/08 10:22 12 48 (10) Just before a break
04/02/08 17:02 9 31 (W) Two hours late
or:
Date Time Start End Comments
04/01/08 06:15 10 35 First run of day (W)
04/01/08 10:22 12 48 Just before a break (10)
04/02/08 17:02 9 31 Two hours late (W)