Concatenate

Posted by on Dec 31, 2012 in MS Excel | 0 comments


Concatenate

The concatenate function strings together the contents of a series of cells (text1, text2). The order that you select the cells is the order that they are combined into the resulting cell.

Syntax: CONCATENATE(text1,text2,…)

Shortcut: The symbol “&” can also be used instead of the concatenate function (=A2&B2).

Example

Image:Xls2 concatenate.jpg


Leave a Reply