software

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: www.excelforum.com/attachment.php?postid=4434 |
-------------------------------------------------------------------

--
aldaris
------------------------------------------------------------------------
aldaris's Profile: www.excelforum.com/member.php...oamp;userid=32333
View this thread: www.excelforum.com/showthread...hreadid=520894It'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

quot;aldarisquot; gt; wrote in
message ...
gt;
gt; in the screenshot below, i want to merge the cells at the bottom
gt; (-idaman tegas-) so that it looks like the one at the top, -maxisegar-
gt; (all data in one cell rather than spread over several cells). the
gt; person who did the spreadsheet wasn't consistent and now i'm stuck with
gt; over 600 sets of data to change.
gt;
gt; can anyone help me?
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: screen.jpg |
gt; |Download: www.excelforum.com/attachment.php?postid=4434 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; aldaris
gt; ------------------------------------------------------------------------
gt; aldaris's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32333
gt; View this thread: www.excelforum.com/showthread...hreadid=520894
gt;