Replies

Try looking under HELP and search “concatenate” - this is what I found:

Merge cells
When you merge two or more adjacent cells, the cells become one merged cell, and the contents of the upper-left cell are displayed in the center of the merged cell, as shown in the following example.

Text spread and centered over multiple cells
Important Only the data in the upper-left cell of a range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) of selected cells will remain in the merged cell. Data in other cells of the selected range will be deleted.

1.If the data that you want to display in the merged cell is not in the upper-left cell, do the following:
1.Select the data that you want to display in the merged cell, and then click Copy on the Standard toolbar.
2.Select the upper-left cell of the range of adjacent cells that you want to merge, and then click Paste on the Standard toolbar.
2.Select the cells that you want to merge.
Note The cells that you select must be adjacent.

3.On the Formatting toolbar (toolbar: A bar with buttons and options that you can use to carry out commands. To display a toolbar, point to Toolbars on the View menu. If you don’t see the button you want, click the arrows at the right end of the toolbar.), click Merge and Center .
The cells will be merged in a row or column, and the cell contents will be centered in the merged cell.

Note If the Merge and Center button is unavailable, the selected cell may be in editing mode. To cancel editing mode, press ENTER.

4.To change the text alignment in the merged cell, select the cell, and then click Align Left or Align Right on the Formatting toolbar.