Assume that cell A1 contains the data "John", cell B1 contains the data "Smith", to have a full name in another cell, use the following formula:

=(A1 & " " & B1)

Then copy this cell to all other cells in full name column.