If you have multiple cells that contain text and you want to join or merge them in one cell then you can use the concatenate function.
CONCATENATE(text1, text2, text3 ……)
You can concatenate up to 255 items into one text string.
Cell A1 = “MBA”
Cell B1 = “Master of Business Administration”
Cell C1 contains the formula: CONCATENATE(A1; B1)
The value of C1 will be “MBAMaster of Business Administration”
You can also use literals (fixed text) in the CONCATENATE function. E.g. if C1 has the formula:
CONCATENATE(A1; “ – “; B1
Then the value of C1 will be “MBA – Master of Business Administration”
You can also use the ampersand (&) calculation operator to achieve the same result as the CONCATENATE function. The last example will look like this:
=A1 & ” – ” & B1