Merging cells and keeping their contents

[robertadc]

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

 

[Guest]

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]

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