The CONCATENATE function is used to join two or more separate texts into a single text.


=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

Learn MS Excel

Ask Questions

Ask Question