CONCATENATE joins up to 255 text strings into one text string. The joined items can be text, numbers, cell references, a space, a symbol or a combination of those items.
For example, if your worksheet contains a first name in column A and the last names in column B, you can combine the two values in another cell by using concatenate