Try this:

Click in C1, then,
<Ctrl <Shift < ~
Then <F2,
Then <Enter

If it now works, that means that your C1 cell was formatted as Text before
the formula was entered.

What you did to get it right was use a keyboard shortcut to format the cell
as General, then enter Edit mode, then register the formula.

So, make sure your cells are either formatted to General or Number before
you enter the formulas.

Now, if those keystrokes *didn't *work, try this:
<Tools <Options <View tab,
And under "Window Options",
*UNCHECK* "Formulas".
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"joey" wrote in message
...
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