Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-09-2019, 09:48 AM
cglenn cglenn is offline Merge cells (multiple rows) causing loss of formatting within merge area Mac OS X Merge cells (multiple rows) causing loss of formatting within merge area Office 2008 for Mac
Novice
Merge cells (multiple rows) causing loss of formatting within merge area
 
Join Date: Aug 2011
Posts: 17
cglenn is on a distinguished road
Question Merge cells (multiple rows) causing loss of formatting within merge area

Using both Word for Mac 2008 and 2011, same results. I will attach the file if this explanation is insufficient. I am not a hard core user.



Backgound: Every year I download a complete NFL schedule and then convert it into tables. Each year, I have been able to find a version that was easily imported and edited, but this year, I have an issue.

The "pasted as unformatted text" document correctly converts to a table (using tab as the column divider), but this time, instead of one column saying the team matchup (e.g., Green Bay at Chicago), it is three columns (e.g., Green Bay Packers | at | Chicago Bears). Note there are additional columns before and after these three (e.g. Date, Time).

I tried this for the whole table and one week's worth of games (17 rows), and the same result happens (including, in the 2008 version, after I "Table>Autoformat>grid 1"). If I select only one row, all is successful, but that's like almost 300 rows in the table.

I select the three columns, use Merge Cells, and the result is three lines of text (e.g., Green Bay [hard return] at [hard return] Chicago). I then select the "[hard return]+at+[hard return]," paste that into Replace, and replace with "[space]+at+[space]." While it replaces text correctly, the result is that the selected area looses it's screen-visible grid lines and the text, without grid lines, is now not aligned with, nor linked to, the cells on either side of the merge selection.

Is there a trick I don't know? Although I've never written (successfully) a macro, I suppose I could create one that converts this, line by line, but I'm wondering if I just need to be educated.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge cells (multiple rows) causing loss of formatting within merge area Mail Merge with multiple rows of data empresslee Mail Merge 7 04-04-2019 03:07 PM
Merge cells (multiple rows) causing loss of formatting within merge area Mail Merge for multiple rows for the same name lfcreds11 Mail Merge 1 09-25-2018 02:51 PM
Merge cells (multiple rows) causing loss of formatting within merge area Mail merge multiple rows eduzs Mail Merge 3 09-03-2018 04:56 AM
Formula that can merge multiple rows with the same ID into one row Hilwey Excel 3 07-08-2015 08:50 PM
Merge cells (multiple rows) causing loss of formatting within merge area Mail Merge multiple rows? ender541 Mail Merge 1 08-21-2012 03:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:27 PM.


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