CONCATENATE (+ video tutorial)

CONCATENATE function joins up to 255 text strings into one text string. The joined items can be text, numbers, cell references, or a combination of any of these.

If your worksheet contains a first name in cell A1 and the last name in cell B1, you can combine the two in another cell by the following formula:

=CONCATENATE(A1,B1)