Excel 2007 Cell and content merging, splitting

The merge and split operations for Excel 2007 include merging and splitting cell and cell content.

Merge cells or split merged cells

When you merge two or more adjacent horizontal or vertical cells, the cells become large cells that appear across multiple columns or multiple lines. The contents of one of the cells appear in the merged cells merged cells: a single cell created by two or more selected cells. The cell reference for the merged cell is the upper-left cell of the original selection. ), as shown in the following example.

You can split merged cells into multiple cells, but you cannot split cells that are not merged.

Merging adjacent cells

1, select two or more adjacent cells to merge.

Note Make sure that the data that you want to display in the merged cells is in the upper-left cell of the selected range. Only the data in the upper-left cell will remain in the merged cells. The data in all other cells in the selected range will be deleted.

2, on the Start tab, in the Alignment group, click Merge and Center.

The cells are merged in one row or column, and the contents of the cell are centered in the merged cells. To merge cells without centering the contents, click the arrow next to center after merging, and then click Cross Merge or Merge cells.

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

3. To change the alignment of text in merged cells, select the cell, on the Start tab, in the Alignment group, click any of the alignment buttons.

Split merged cells

1, select the merged cells.

When you select a merged cell, the Merge and center button is also displayed as selected on the Alignment group on the Start tab.

2, to split the merged cells, click Merge and Center.

The contents of the merged cells appear in the cell in the upper-left corner of the split cell range.

You can merge the contents of several cells and display them in a cell. You can also split the contents of a cell and distribute it as parts in other cells.

Merge or split cell contents

Merge the contents of multiple cells into a single cell

You can use formulas with the join symbol (&) operator to merge the text of multiple cells into a single cell.

1, select the cells in which you want to merge the contents of other cells.

2, to start the formula, please type = (

3. Select the first cell that contains the text you want to merge, type & & (there is a space between the double quotes), and then select the next cell that contains the text you want to merge.

To merge the contents of more than two cells, continue to select the cells and make sure to type & "&" between the selected cells. If you do not want to add spaces between the merged text, type & instead of & "&. To insert a comma, type & "," & (between quotes, followed by a comma and a space).

To complete the formula, type)

To see the results of the formula, press ENTER.

Tip You can also use the CONCATENATE function to merge the text of multiple cells into a single cell.

Example

The following sample worksheet shows the available formulas that you can use.

If you copy the example to a blank worksheet, it may be easier to understand the example.

> How to copy Samples

1. Create a blank workbook or worksheet.

2, select the example in the Help topic.

Note Do not select row or column headings.

Select the sample from Help

3, press CTRL + C.

4, in the worksheet, select cell A1, and then press CTRL + V.

5. To toggle between viewing the results and viewing the formulas that return the results, press CTRL + ' (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.

	A	B
1	Name	Surname
2	Nancy	Davolio
3	Andrew	Fuller
	Formula	Description (Results)
=a2& "" &b2	Merge the name above, separated by a space (Nancy Davolio)
=b3& "," &a3	Merge the name above, separated by a comma (Fuller, Andrew)
=concatenate (A2, "", B2)	Merge the name above, separated by a space (Nancy Davolio)

Note by using the spaces in quotation marks, the formula inserts a space between the last name and the first. Any text text that is enclosed in quotes in the result, and the text does not change.

Splits the contents of a cell into multiple cells

1, select the cell that contains the text value that you want to distribute to other cells, range area: two or more cells on the worksheet. Cells in a range can be contiguous or nonadjacent. ) or the entire column.

The height of the annotation area can be any number of rows, but the width can only be one column. You also need to keep enough empty columns to the right of the selected column to prevent existing data from being overwritten by the data that will be distributed.

2, on the Data tab, in the Data Tools group, click Columns.

3, follow the instructions in the "Text Breakdown Wizard" To set how to split the text into columns.

Note For help on completing all the steps of the wizard, click Help in the Convert to Text Column Wizard.