result of formula not displaying
 

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?

result of formula not displaying
 

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?

result of formula not displaying
 

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?

result of formula not displaying
 

It sounds like your cell may be formatted as text.
Remove the formula, from the Format Menu Select CellsNumberGeneral.
Then retype the formula.

Hope this helps
Rowan

Stupid Word User wrote:
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?

result of formula not displaying
 

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?