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?