I am really not Excel savy. My cells are actually C (first name) and D (last
name). When I try and put the formula in cell D2, it gives me error
messages. I hate to be a bother, but I really need to get this done as soon
as possible. Thanks for all your help!!

"Sean Timmons" wrote:

Did you do that last part... copy he newly created column and paste
special/values?

You should be able to go to Edit Undo and click til you get back to the
values where you need them and do that last part.

Verify it worked by clicking in one of the new cells and looking in the
formula bar. Make sure the value is in there, not the formula.

"kolds" wrote:

Once I get my formula in, I deleted column "A" and "B." When I did that my
new column was messed up. What do I do now?

"Sean Timmons" wrote:

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!