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


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).


Image:Xls2 concatenate.jpg

Leave a Reply