Excel Tips No 3 : Combining Text in Excel

This free microsoft excel tips no 3 is telling to combine text/word from several different cell.

To combine text/word from several different cell we can use function "concatenate"


In this example: we need to combine text in coloumn B4 and C4
The formula is "=concatenate(text1,text2,text3,...)
1. Click the cell you want to put the result
2. Type the Function, ie: in cell D4 "=concatenate(B4,C4)

If we want copy the result to another cell/sheet, dont forget to copy only the value of the cell:
1. Click the cell you want to copy
2. Click Copy or you can use short cut "Ctrl + C"
3. Click Cell Destination
4. Right Click your mouse, select "paste Special"
5. Select Value
6. Click OK