I have a very simple search function (=SEARCH(" ",E2)) in my formula and when
i hit enter it only displays the formula, not the result. The formula is
right and in the preview it shows the correct value. Why will it not display
this value?