See Results of Formula rather than the Formula Itself

[Guest]

Hi guys is there anyway to actually solidify the results of a formula. For
Example, if i click the cell can i see the RESULTS of the formula, rather
than the FORMULA ITSELF?
For example
Column C will say
| American Online |
But when i click it, all i see is the formula, (=SUBSTITUTE(B3,A3&", ","") ...
can i remove the formula and only see the result of the formula?

 

[Guest]

When you click on it, the formula shows up in the cell itself, or up in the
formula bar? You can't change that, if you want to change the formula into
the value, you need to copy/edit/paste special and pick values.

 

[Guest]

The formula bar always shows the formula, but
CNTRL-~
will toggle the cell cedisplay between result & formula

 

[Guest]

Hi,

Range the cells (highlight them) and the right click on the range choos copy
and then right click again and choos paste special and then choos value and
click ok.

Thanks,