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


G

Guest

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/com...5-aad4dec5d1e2&dg=microsoft.public.excel.misc
 
Ad

Advertisements

G

Guest

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.
 
Ad

Advertisements

E

Earl Kiosterud

Tile,

We've been saying not to use merge cells for some time now (causes problems
down the line).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top