Merging cells and keeping their contents

How do I merge cells in a row and keep the contents (text) of all of them?

I have an existing spreadsheet that has text in multiple cells accross a row. I need to have the spacing between each character in the row the same when printed. I am using a fixed-width font (Courier) to keep the spacing between each character the same, but there is additional spacing between each cell. I thought I could merge the cells in eash row into one cell, but Excel only wants to keep the contents of the first cell.

Robert

If you merge cells, only the text in the left most cell remains.

Sounds like you want to concatenate, then merge, cells.

Example:

1) Assume text in A1 to C1
2) Enter in D1 the following: =CONCATENATE(A1,B1,C1) (assumes you don't
want any spaces between the concatenated text strings)
3)Copy the contents of D1, pase special, values, in A1. Select A1 through
C1 and merge cells.

Let me know if that gets you where you're looking to be.

"robertadc" wrote:

>
> How do I merge cells in a row and keep the contents (text) of all of
> them?
>
> I have an existing spreadsheet that has text in multiple cells accross
> a row. I need to have the spacing between each character in the row
> the same when printed. I am using a fixed-width font (Courier) to keep
> the spacing between each character the same, but there is additional
> spacing between each cell. I thought I could merge the cells in eash
> row into one cell, but Excel only wants to keep the contents of the
> first cell.
>
> Robert
>
>
> --
> robertadc
> ------------------------------------------------------------------------
> robertadc's Profile: http://www.excelforum.com/member.php...o&userid=37653
> View this thread: http://www.excelforum.com/showthread...hreadid=572630
>
>

I want to keep all text characters that are in the cells including spaces. I think I found a workable solution by combining the values of the cells into a new cell (=A2&B2&C2&D2&E2&F2&G2&H2&I2&J2&K2&L2&M2&N2&O2&P2&Q2&R2&S2&T2&U2).

Robert