EXCEL : CONCATENATE FUNCTION

the CONCATENATE function, is used to join two or more words or text strings together.

The syntax for the CONCATENATE function is:
= CONCATENATE ( text1, text2, ... )

Based on the Excel spreadsheet, the CONCATENATE function would return the following:

=CONCATENATE(B2, C2) would return "Elephant"