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

If Cell is This Value or That Value

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of logical test. If you want to see if a cell is A or B, and if one of ...

If Value is Greater Than A Certain Value
If Value is Greater Than A Certain Value 1

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the logical test result. If you want to see if a value in one cell is greater than a specific value, ...

If Cell is Not Blank
If Cell is Not Blank 6

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if a cell is blank or not, and leave some ...

VBA Macro For VLOOKUP From Another Sheet
vba macro for vlookup from another sheet1

In the previous post, you should know that how to fix or remove the #N/A error when using VLOOKUP formula to lookup value from another sheet. And this post will show you how to use VBA code to vlookup data ...

If Cell is Blank
If Cell is Blank_1

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if a cell is blank or not, and leave some ...

If Cell Equals Certain Text String
If cell equals certain text_1

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if cell equals a certain text string like “Win”, you ...

If Cell Contains Either Text1 or Text2
If cell contains text1 or text2_1

IF function is frequently used in Excel worksheet to return “true value” or “false value” based on the logical test result. If you want to see if cell contains certain substring1 like “abc” or substring2 like “def”, and returns true ...

If Cell Contains Certain Text OR Equals Certain Text

IF cell equals certain text IF function is frequently used in Excel worksheet to return “true value” or “false value” based on the logical test result. If you want to test values to see if they equal certain text like ...

VLOOKUP From Another Sheet Not Working
vlookup from another sheet not working3

In the previous post, you should know that how to fix or remove the #N/A error when using VLOOKUP formula to lookup value from another sheet. And this post will show you reasons why your VLOOKUP formula is not working ...

If Cell Begins with One of Three Supplied Characters
If Cell Begins with One of Three Supplied Characters

If you want to test values to see if they begin with some given specific characters like “x”, ”y”, or “z”, you can create a formula with COUNTIF and SUM functions to return results. EXAMPLE You can see “TRUE” or ...

Sidebar