J
jameshanley39
how do I replace formula with value or cell code with value ?
excuse my terminology.
consider that just a subject title !!
I have 2 questions..
based on that concept
A)
suppose some cells have formulae like
=A4+5
=F3*2
If I copy and paste those cells, I get the formula in another cell.
How do I copy the value, paste the value. Not the formula?
(Note, i know using notepad can.. i'm wondering if excel alone can)
B)
How do I turn
=A4+F3+H7
into
=4+6+3
i.e. I want the formula in there. But not the original A4+F3+H7
formula. I want the =4+6+3 formula.
even notepad doesn't help me there.
excuse my terminology.
consider that just a subject title !!
I have 2 questions..
based on that concept
A)
suppose some cells have formulae like
=A4+5
=F3*2
If I copy and paste those cells, I get the formula in another cell.
How do I copy the value, paste the value. Not the formula?
(Note, i know using notepad can.. i'm wondering if excel alone can)
B)
How do I turn
=A4+F3+H7
into
=4+6+3
i.e. I want the formula in there. But not the original A4+F3+H7
formula. I want the =4+6+3 formula.
even notepad doesn't help me there.