Merge and Combine text cells in Microsoft Excel, concatenation


Sometimes you need to merge certain text from multiple cells to create a whole and you can combine or merge text from two or more cells into one cell in Microsoft Excel.

For example, if you want to merge only two cells like A and B into C cell in Excel just follow those steps :

1. Type text in A and B cells
2. Type in C cell =(A1&” ” &B1) and you will have all text from A and B cells combined .

If you want to combine more than two cells you can do it in a simple way using concatenation with a simple concatenation commands in Microsoft Excel.

For example, you can enter text in different cells, eg. cells A, B, C, D, E from 1 to 10 .

1. Click the cell F1,
2. Enter the formula = CONCATENATE (A1 & B1 & C1 & D1 & E1)
3. Type enter,
4. Then the corner Close the cell over the cells next to the F10.

In cells F1 to F10 will appear merged cells texts mentioned above !

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet - Rate this article !)

Lost Password