OT Excel Question
T Rex
>I have a formula in a cell that I want to change to the value that is calculated and not the formula.
Cell A2 contains ABC.
Cell B2 contains =A2.
I want cell B2 to contain ABC not the formula.
How do I do that?
TIA,
T Rex
Knowledge You Can Build On — Est. 1998
OT Excel Question
T Rex
>I have a formula in a cell that I want to change to the value that is calculated and not the formula.
Cell A2 contains ABC.
Cell B2 contains =A2.
I want cell B2 to contain ABC not the formula.
How do I do that?
TIA,
T Rex
Re: OT Excel Question
Bob Entwisle in NJ
>copy cell B2, then right click and "paste special" and select "Values"
Re: OT Excel Question
T Rex
>Superb!!!
Thank you very much.