some merging question

[aldaris]

in the screenshot below, i want to merge the cells at the bottom
(-idaman tegas-) so that it looks like the one at the top, -maxisegar-
(all data in one cell rather than spread over several cells). the
person who did the spreadsheet wasn't consistent and now i'm stuck with
over 600 sets of data to change.

can anyone help me?


+-------------------------------------------------------------------+
|Filename: screen.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4434 |
+-------------------------------------------------------------------+

 

[Peo Sjoblom]

It's better to remove all merge cells and use center across selection, if
you have lots of merged cells you are bound to getting in trouble later

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon