CONCATENATE Function
The CONCATENATE function is used to join two or more separate texts into a single text.
Formula:
=CONCATENATE(Text 1, Text 2,...up to Text 255)
Whereas Text 1, Text 2,... are the texts that have to be joined.
Video Tutorial:
Let us learn how to join texts, using the CONCATENATE function, with the help of the below video
