Tech Tip

Combining text in multiple Excel cells

In Microsoft Excel, you can use the ‘&’ symbol to consolidate text information in the same way as you use the ‘+’ sign to add numbers. For spacing out the words, you could use a quotation mark. Here is how you can do this :

Step 1 : Enter the text ‘This’ in cell A1.
Step 2 : Enter the text ‘tip’ in cell A2.
Step 3 : Enter the text ‘is great’ in cell A3.

Now to combine the text in cell A5, type the following formula :
=A1&” “&A2&” “&A3
The output in cell A5 is: This tip is great.