Assuming your first name is in cell A2, last name in cell B2, in cell B2,
type =A2&" "&B2
Copy formula all the way down.

Once done, highlight column C, copy, Right-click and paste special..., Values.

"kolds" wrote:

We have many excel spreadsheets that we use to track employees. My company
just recently transfered the info from Word to Excel. I am new to the
company and fairly new to Excel. We have decided to merge the name cells
from two to one (one cell-first name, one cell-last name). We want to do
this to help in our searches for people. I have no idea how to do this. I
am sure there has to be an easier way than retyping everyone name into one
cell. Any advice would be appreciated!