How to Combine Text from many Cell using the & : Excel Tip

For Microsoft Excel, we usually use various formula to calculate the number but the formula can also be used in text operation. This tips I will let you know how to combine text from different cell. I will take the symbol, &, called Ampersand to operate the combination of text. The syntax we must put in cell is :

=Cell1&” “&Cell2&” “&Cell3

& >>> to combine any cell or any text.
” ” >>> to show one space for separating the text.

I give you an example to make it easy to understand. Please follow this below.

- Open Microsoft Excel program.
- I enter the text “This is” and “Excel Tip” in A1 and A2 cell respectively. Please see the picture.
- Now I put the formula, =A1&” “&A2, in A3 then press Enter. Therefore you get the A3 cell converted to the text “This is Excel Tip”.
- All done with ease.