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





& concatenates two values to produce one continuous text value, for example "Total"&"Profit"
& 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 OperatorText concatenation Operator
6.11.4.OPERATOR PRECEDENCE IN EXCEL FORMULAS
6.11.5.Determining Whether Two Strings Are IdenticalDetermining Whether Two Strings Are Identical
6.11.6.To add a space between the two entries when joining Two or More Cells: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 CellsUse a comma and a space between the two entries when joining Two or More Cells