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,
--
Farhad Hodjat


"Johnny B" wrote:

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?