To add a space between the two entries when joining Two or More Cells: : Operators « Formula « Microsoft Office Excel 2007 Tutorial






Input the formula: =A1&" "&A2
Input the formula








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