You need to format your cell as something other than Text before you
enter your formula.

In article ,
"Roger" wrote:

I have tried using TRIM, but all that happens is that I can see the formula
in the cell (ie I can see =TRIM(D2)) and it doesn't actually work. Do I need
to turn this function on somehow to see the result?