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 !
(No Ratings Yet - Rate this article !)
Loading...
