Well, for me, it worked. I put Jorge Manuel in E2 and the result was 6...

And, for a second space, worked too: I put Jorge Manuel Rod, and the result
was 13. The formula: =SEARCH("#";SUBSTITUTE(E2;" ";"#";2)) [semi-colon is in
Portugal...]
regards.

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

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