Home » Microsoft Excel 2003 » 05 - Working With Formulas
5
Using Text Formulas
A text formula is a formula that returns text. Text formulas use the ampersand (&) operator to work with text strings enclosed in quotation marks.
For example, if you enter the formula ="sea"&"side" into a cell, Excel displays the resulting text as seaside.
The ampersand can also be used to combine cells that contain text.
1. In cell A1, enter the text Tom
2. In cell A2, enter the text Jerry.
3. In cell A3, enter the formula =A1&" and "&A2
4. The text Tom and Jerry will be displayed.
