That is what I have in the formula. I just used parentheses here. The
formula is exactly as you show it.

"JRod" wrote:

The right formula is: =SEARCH(" ",E2)

--
JRod
Microsoft MVP - Excel
http://EXCELer.blogspot.com

"Stupid Word User" escreveu na
mensagem ...
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?