Home Articles Forums Gallery Marketplace Videos

WoodCentral Forums

Knowledge You Can Build On — Est. 1998

VPS-Level Performance. Fully Managed. No Hassle.

OT Excel Question

Posts

OT Excel Question

#1

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

#2

Re: OT Excel Question

Bob Entwisle in NJ

>copy cell B2, then right click and "paste special" and select "Values"

Re: OT Excel Question

#3

Re: OT Excel Question

T Rex

>Superb!!!

Thank you very much.