How to Copy Two Cells & Paste Into One Cell in Excel 2007
Spreadsheets can be indispensable for storing data in a meaningful way, but it becomes a true time-saving tool when you learn how to use formulas to automatically group or process data for use elsewhere. For example, you might have a list of names and addresses. First names might appear in one cell while last names appear in the next. If you wish to extract the data for use in another program, you might find yourself doing more cutting and pasting than necessary. An easy way exists to copy the data in two cells and paste them together into one cell. This process is called concatenation.
Other People Are Reading
Instructions
-
-
1
Select the cell into which you want to enter the concatenated text.
-
2
Enter the following formula into the target cell:
"=Cell1&" "&Cell2"
Replace Cell1 and Cell2 with the actual cell locations you wish to concatenate. For example, if you are wishing to join the data from cells A2 and B2, the formula you would enter would be "=A2&" "&B2." The quotes and space between ensure there is a space between the two separate entries, such as you would need if you were merging first and last names. If no space is needed, the formula would read as follows: "=A2&B2."
-
-
3
Copy the formula to concatenate the information throughout your spreadsheet. To do this, double-click the "fill handle"--that's the darker square dot in the lower-right corner of the cell pointer (when you are in the right spot your mouse pointer will turn into a cross). Excel will automatically fill all other cells in the range with information according to your formula.
-
1
