Format that cell (whole column????) as General (format|Cells|Number tab)

Then reenter the formula
(select the cell, then F2 followed by Enter should be enough)

joey wrote:

I copied the formula you sent into the C1 field but I get no result, only the
formula displaying. Am I doing something wrong?

"joey" wrote:

I know that this has been answered many times, but I can't find my note. I
have a column of students first names and a column of students last names.
How can I group them with a space into the third column?

Thanks in advance.

Joey

--

Dave Peterson