Horizontal merging of cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

srhermele@gmail.com - 28 Mar 2008 19:18 GMT

I saw the "merge" button and tried it and a window opened up and told
me some information may be lost, and lost it was! What good is that
and how can get around it.

More specifically, I've got say 4 cells to merge into one and I've got
500 rows of text data to merge into 1 cell per row, how can I do this?

Thanks

Reply to this Message

Gord Dibben - 28 Mar 2008 19:31 GMT

Don't merge, combine instead.

Stay away from merged cells if at all possible. They cause no end of problems.

In a helper column, say column E enter in E1

=A1 & B1 & C1 & D1

Double-click on E1 fill handle to copy down.

When happy, copy column E and Paste Special(in place)>Values>OK>Esc.

Delete A to D columns.

Note: to have a space between each use

=A1 & " " & B1.....................& D1

Gord Dibben MS Excel MVP

>I saw the "merge" button and tried it and a window opened up and told
>me some information may be lost, and lost it was! What good is that
[quoted text clipped - 4 lines]
>
>Thanks

Reply to this Message