| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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? |
|
#5
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
| Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
Hybrid Mode
