How to use "CONCATENATE" Function in Excel

This function joins separate pieces of text into one item.

Syntax:
 =CONCATENATE(Text1,Text2,Text3...Text30)

Example:

Here is the video tutorial of the same for clear understanding.

Back to MS Excel>>