Excel function CONCATENATE

CONCATENATE joins letters/words/numbers/etc. into a single text string.

Select the CONCATENATE function and then enter references to the cells containing the letters or words to join.

concatenate function - concatenate

In this example, the 5 letters have been joined into a single string.

concatenate - concatenate