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:
Step 1: Select a cell to save the texts from multiple cells, for example D2, then in D2 enter
Step 2: Click Enter to get result. Verify that texts are moved into D2 properly.
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.
Clipboard in excel:
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.
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.
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.