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" <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?
>>
>>
>>