How to Copy and Paste Two Cells Into One Cell

By Colby Stream

Merging multiple cells into one can save you time, in a retroactive sense. The process, called "concatenating," allows you to take multiple cells which you have already typed information into and merge the information into one single cell without losing information. While the nature of the product sounds like you should be able to copy and paste from one cell into many, that process will only get you headaches and frustrations. Instead, you can use an easy formula that will only take you a few steps to master.

Step 1

Open the existing Excel document in which you would like to merge multiple cells into one. If an already existing document is not available, create one by putting the information you would like in one cell into multiple.

Step 2

Select the one cell in which you would like to insert all the information. Write "=(" into the formula, minus the quotation marks. This begins the formula of the merging project.

Step 3

Write the cell name of the first cell you would like to merge and then insert an ampersand and quotation mark. For example, if you are merging cell A1 as part of the data, write "=sum(A1&" ". Before writing the name of the next cell, insert a space followed by a quotation mark and an ampersand. Write the name of the cell and then end the same way you ended the first cell block.

Insert all the information as described in Step 3. After the last cell block has been written, close the parentheses. The formula should look like this: "sum=(A1&" "&B1&" "&C1&" ... "&E1&")" without the outer two quotation marks. Press "Enter." Your information will appear in the order you inserted it.