Excel should have the option to merge contents when merging cells.
 

When Excel merges cells, it keeps only the upper-left-most contents and
deletes the others. It would be nice to have the option (maybe a toggle
button in the options menu) to concatenate the contents of all the merged
cells, so that the information in the lower-right cells is tacked onto the
end of the information inthe upper-left-most cell. This is not a big deal,
but it would be a nice bell/whistle to save some steps.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

There is an interesting little known fuction Concatenate that when use
properly joins data from multiple cells like Wednesday - August - 31 - 2005
and by adding a " " and ", " in there you can get -Wednesday, August 31,
2005. use the help file. I do this repetedly with information from Sheet 1
into a cell on Sheet 2. That is what the multiple sheets and formulas are
there for. to assist you in combining information that you input into
different cells.

"Ceiling Tile 01" wrote:

When Excel merges cells, it keeps only the upper-left-most contents and
deletes the others. It would be nice to have the option (maybe a toggle
button in the options menu) to concatenate the contents of all the merged
cells, so that the information in the lower-right cells is tacked onto the
end of the information inthe upper-left-most cell. This is not a big deal,
but it would be a nice bell/whistle to save some steps.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Tile,

We've been saying not to use merge cells for some time now (causes problems
down the line).
--
Earl Kiosterud
www.smokeylake.com

"Ceiling Tile 01" <Ceiling Tile wrote in
message ...
When Excel merges cells, it keeps only the upper-left-most contents and
deletes the others. It would be nice to have the option (maybe a toggle
button in the options menu) to concatenate the contents of all the merged
cells, so that the information in the lower-right cells is tacked onto the
end of the information inthe upper-left-most cell. This is not a big
deal,
but it would be a nice bell/whistle to save some steps.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc