Microsoft Excel 2010
Concatenating refers to joining information located in more than one cell. For example, you may have first names listed in one column and last names listed in another. To create a column that combines the first and last name, use the concatenating feature.
Example: Let's say A1 contains John and A2 contains Smith.
In cell A3 you wish to display John Smith. Your formula should look
like this: =A1&" "&A2 If you didn't include the " " in your formula, the result would be JohnSmith.