Once the cells have been merged, they can be unmerged as well. Hence, the content of cells A2 and B2 has been merged. The output appears in cell D2, as shown in the following image. Step 1: Enter the following formula in cell D2. The steps to merge cell values with the ampersand operator are listed as follows: Working on the data of example #1, we want to join the first and the last name with the help of the ampersand. The formula for combining the values of cells A2 and B2 with a space in between is “=A2&” “&B2”īy using the ampersand, no data string is lost while merging cell values in excel. The ampersand operator combines different text strings by the insertion of “&” within the formula. Hence, the values of cells A2 and B2 are merged. The output appears in cell C2, as shown in the following image. Step 2: Enter the following CONCATENATE formula in cell C2. Step 1: Select the cell C2 in which the output is required. The steps to merge cell values with the CONCATENATE formula are listed as follows: Working on the data of example #1, we want to merge the first and the last name with a space in between. Part 3 (B2): This is the second cell reference to be joined.Part 2 (” “): This is the delimiter “space” that separates the values of the two cells.Part 1 (A2): This is the first cell reference to be joined.
![how to merge cells in excel how to merge cells in excel](https://cdn.extendoffice.com/images/stories/doc-excel/merge-cells/doc-merge-columns-into-one-cell-1.png)
The three parts of the function are explained as follows: The following image illustrates the CONCATENATE formula for joining the values of cells A2 and B2 with a space in between. This function ensures that no data string is lost while merging cell values in excel. In other words, the values of several cells are joined together in one cell. The CONCATENATE function combines or concatenates the content of two or more cells. We want to merge the two names with the help of the “merge and center” option. The following table shows the first and the last names in columns A and B respectively. Note 2: The excel shortcut for merging (merge and center) is “Alt+H+M+C” and for unmerging is “Alt+H+M+U.” Both the shortcuts must be pressed one by one. Note 1: The difference between the options “merge and center” and “merge cells” is in the alignment of the merged output. Unmerge cells: This unmerges the cells implying that the merged cells are split into separate cells again.It retains the text of the upper-leftmost cell only.
![how to merge cells in excel how to merge cells in excel](https://cdn.extendoffice.com/images/stories/doc-excel/merge-cells-in-table/doc-merge-cells-in-table-5.png)
The cells can be selected either horizontally or vertically, or both. Merge cells: This merges all the selected cells into one single cell.It merges the values of one row at one time. Merge across: This merges across, implying that the selected cells of the same row are joined together.The text of the remaining merged cells is deleted. While merging, it retains the text of the upper-leftmost cell only. Merge and center: This merges the selected cells and places the data string in the center.The different options of the “merge and center” drop-down are explained as follows: It can be found under the “alignment” group of the Home tab, as shown in the following image. The “ merge and center” drop-down consists of various merging options that help combine multiple cells into one. Thereafter, some relevant examples are taken up. We discuss the three merging techniques followed by a few more topics.
#How to merge cells in excel how to#
Let us understand how to merge cells in Excel. The different ways of merging cells in Excel are listed as follows: Before merging, it is essential to select the cells to be merged. This option merges the cells and not their values. “Merge and center” is an in-built button of merging excel cells placed under the Home tab of Excel. The large cell thus created is displayed across multiple columns or/and rows. Since merging creates a large cell by joining several small ones, the task of resizing individual cells is eliminated. The purpose of merging excel cells is to make the data presentable and readable for the end-user. Hence, to place the title “financial statements” in the center of the data, the cell range A1:H1 has to be merged. This data is spread across columns A to H. Merging excel cells is specifically required when a heading or title has to be centered over an area of a worksheet.įor example, a worksheet contains a balance sheet, a profit and loss account, and a cash flow statement. Merging a cell in excel refers to combining two or more adjacent cells either vertically, horizontally or both ways.