Text concatenation Operator : Operators « Formula « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Formula
3. Operators

& concatenates two values to produce one continuous text value, for example "Total"&"Profit"

6.11.Operators
	6.11.1.	Arithmetic Operator
	6.11.2.	Comparison Operator
	6.11.3.	Text concatenation Operator
	6.11.4.	OPERATOR PRECEDENCE IN EXCEL FORMULAS
	6.11.5.	Determining Whether Two Strings Are Identical
	6.11.6.	To add a space between the two entries when joining Two or More Cells:
	6.11.7.	Use a comma and a space between the two entries when joining Two or More Cells