Microsoft Office Tutorials and References
In Depth Information
Using Formulas to Join Text
Figure 9.6. The & operator is used to join two text cells.
The & operator is used to join two text cells.
When using the & operator, you might want to include a space between the two
items that are combined to improve the appearance of the output. For example,
if the cells contain first name and last name, you might want to have a space
between the names. To include a space between cells, you follow the & with
=A2&" "&B2 generates a better-looking result than =A2&B2.
Figure 9.7. You can join cells with any text in quotation marks.
You can join cells with any text in quotation marks.