Did you actually enclose your formula in quotes? If so that's your problem.
The other way is if your cell was formatted to Text before you entered the
formula. Change the format to General, then re-enter the formula.

BTW, the shortcut to Concatenate is &, as in:
=d10&d11

Regards,
Fred.

"JennieSarah" wrote in message
...
Hi;

Im hoping that im making a really silly error here myself but I really
cannot see whats wrong and getting frustrated!
Im using the Concatenate function within my worksheet but after setting up
the function and pressing the enter key, nothing happens at all. No result
is
shown for the formula, just the formula itself is displayed within the
cell:
'=concatenate(d10,d11)'
I have already checked to make sure that the worksheet is not set up to
show
the formulas and have tested out anything that I think could be affecting
it
but to no avail.
Are there certain types of cell contents that cannot be used with this
function or is there something that I am missing perhaps?

Any help is greatly, greatly appreciated!

Many thanks,
Jen