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 |
+-------------------------------------------------------------------+

--
aldaris
------------------------------------------------------------------------
aldaris's Profile: http://www.excelforum.com/member.php...o&userid=32333
View this thread: http://www.excelforum.com/showthread...hreadid=520894

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




"aldaris" wrote in
message ...

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 |
+-------------------------------------------------------------------+

--
aldaris
------------------------------------------------------------------------
aldaris's Profile:
http://www.excelforum.com/member.php...o&userid=32333
View this thread: http://www.excelforum.com/showthread...hreadid=520894