How to Move Texts from Multiple Cells into One Cell in Excel

Sometimes in our daily work we need to move texts from multiple cells into one cell for some reason. If we want to split texts from one cell to multiple cells, we can use Text to Columns function, so if we want to combine texts from multiple cells into one single cell, how can we do? This article will show you two ways to implement the requirement, and you can select one of them as you like.

Move Texts from Multiple Cells into One Cell by Formula Concatenate


Prepare a table with texts or numbers in different cells, see screenshot below:

Move Texts from Multiple Cells into One Cell 1

Step 1: Select a cell to save the texts from multiple cells, for example D2, then in D2 enter

=CONCATENATE(A1,”:”,A2,”:”,B2,”,”,A3,”:”,B3,”,”,A4,”:”,B4).

Move Texts from Multiple Cells into One Cell 2

Step 2: Click Enter to get result. Verify that texts are moved into D2 properly.

Move Texts from Multiple Cells into One Cell 3

Notes:

1. In above case, A1, A2… are the cells you want to copy the values from them into one single cell;

2. We can find that we add “:” or “,” into the formula, actually there is no punctuation like comma or colon exists in cells before, but they are added into D2 finally, that’s because we use double quote to make them as the separators for each cell. You can add separator per your preference.

Move Texts from Multiple Cells into One Cell by Clipboard


We can use clipboard as the temporary media to save the texts from all cells for a short time. Then copy the texts in clipboard to a single cell to implement our requirement. See steps below:

Step 1: We need to enable the Clipboard. In Home->Clipboard panel, click arrow key to expand Clipboard.

Move Texts from Multiple Cells into One Cell 4

Clipboard in excel:

Move Texts from Multiple Cells into One Cell 5

Step 2: Select the range you want to move the texts from them into one single cell, in this case we select A1:B4, press Ctrl + C to copy them. You can find that texts are moved to Clipboard properly.

Move Texts from Multiple Cells into One Cell 6

Step 3: Select the destination cell to save the texts, for example D2, then double click the cell to locate cursor into the cell.

Step 4: Press Ctrl + V or click on the texts in Clipboard (Click an Item to Paste) in this cell. Then All texts are saved in D2 properly.

Move Texts from Multiple Cells into One Cell 7

Notes:

1. By this way the separator is ‘space’ for each cell.

2. The final behaviors are different by above two ways. So you can select one of them based on the behavior.

 

Related Posts

Match Single Criteria in Excel

No repeat statistic based on a single condition is used wildly in daily work, for example, count type of products, the duplicate types are not encountered. This article describes the way of no repeats statistics for data in a single ...

Excel Array Construction

This article will talk about how to create one-dimensional array or two-dimensional array by using some functions in Excel. When using array formulas in Excel, we often use functions to construct arrays. Generate Array with ROW or COLUMN Functions Array ...

Excel Array Operation

We have all heard of arrays. Depending on the dimensionality, they are divided into one-dimensional arrays and two-dimensional arrays. Depending on the data type, they can also be divided into numeric arrays, logical arrays, and so on. The concatenation and ...

Excel Array Matrix Operation

In Excel, we have a built-in function used to perform matrix operations. It is the MMULT function. This function accepts two arrays as parameters and returns the product of the two arrays. However, this function has a prerequisite that the ...

A1 Reference Style and R1C2 Reference in Excel

In Excel, there are two reference styles. A1 reference style and R1C2 reference style. These two reference styles can help us find the cell by the cell address. Some functions return these two addresses through the argument settings. A1 Reference ...

Sidebar