CONCATENATE Function

CONCATENATE( )

This function used to combine two or more values (cells values).

Syntax: CONCATENATE(text1,[text2],[text3]......)

Example: =CONCATENATE("microsoft","excel")

Output: microsoftexcel