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?

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

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

"Stupid Word User" <StupidWordUser@discussions.microsoft.com> escreveu na
mensagem news:C8F45479-0E60-48C7-83A5-60D3E1FF24E6@microsoft.com...
>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?

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" <StupidWordUser@discussions.microsoft.com> escreveu na
> mensagem news:C8F45479-0E60-48C7-83A5-60D3E1FF24E6@microsoft.com...
> >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?
>
>
>

It sounds like your cell may be formatted as text.
Remove the formula, from the Format Menu Select Cells>Number>General.
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" <StupidWordUser@discussions.microsoft.com> escreveu na
>>mensagem news:C8F45479-0E60-48C7-83A5-60D3E1FF24E6@microsoft.com...
>>
>>>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?
>>
>>
>>

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" <StupidWordUser@discussions.microsoft.com> escreveu na
mensagem news:B0AF1776-5A3C-4C96-9D42-27F46040EAA1@microsoft.com...
> 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" <StupidWordUser@discussions.microsoft.com> escreveu na
>> mensagem news:C8F45479-0E60-48C7-83A5-60D3E1FF24E6@microsoft.com...
>> >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?
>>
>>
>>