Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace formula to text
Hello:
I would like to replace a formula to the actual text of the formula. Fo E.G. if I have in a cell "=A1", and I want to copy the formula to cell A25, it will copy it like this, "=A25", but I want it to copy exactly like the formula, "=A1". So how can I replace the formula in a cell to the actual text of the formula without using a formula. Hope I'm explaining myself well, If not ask please I'll explaine myself more. I need help on this. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace formula to text
I'm not completely sure I've understood but you could try this
=$A$1 This will remain as A1 no matter where you drag or copy it to. Mike "art" wrote: Hello: I would like to replace a formula to the actual text of the formula. Fo E.G. if I have in a cell "=A1", and I want to copy the formula to cell A25, it will copy it like this, "=A25", but I want it to copy exactly like the formula, "=A1". So how can I replace the formula in a cell to the actual text of the formula without using a formula. Hope I'm explaining myself well, If not ask please I'll explaine myself more. I need help on this. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace formula to text
Try this tiny UDF:
Function equation(r As Range) As String equation = "'" & r.Formula End Function So if A1 contains =1+2+3+4 it will display 10 If you enter =equation(A1) in another cell is will display '=1+2+3+4 -- Gary''s Student - gsnu200771 "art" wrote: Hello: I would like to replace a formula to the actual text of the formula. Fo E.G. if I have in a cell "=A1", and I want to copy the formula to cell A25, it will copy it like this, "=A25", but I want it to copy exactly like the formula, "=A1". So how can I replace the formula in a cell to the actual text of the formula without using a formula. Hope I'm explaining myself well, If not ask please I'll explaine myself more. I need help on this. Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace formula to text
Why do you want =A1 to be text?
I am guessing you want to copy the formula but not have it increment. Change it to an Absolute formula =$A$1 in E1 copied to L1 would be =$A$1 Gord Dibben MS Excel MVP On Mon, 3 Mar 2008 07:17:01 -0800, art wrote: Hello: I would like to replace a formula to the actual text of the formula. Fo E.G. if I have in a cell "=A1", and I want to copy the formula to cell A25, it will copy it like this, "=A25", but I want it to copy exactly like the formula, "=A1". So how can I replace the formula in a cell to the actual text of the formula without using a formula. Hope I'm explaining myself well, If not ask please I'll explaine myself more. I need help on this. Thanks. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace formula to text
Thanks to all three of you. That should be fine.
"Gord Dibben" wrote: Why do you want =A1 to be text? I am guessing you want to copy the formula but not have it increment. Change it to an Absolute formula =$A$1 in E1 copied to L1 would be =$A$1 Gord Dibben MS Excel MVP On Mon, 3 Mar 2008 07:17:01 -0800, art wrote: Hello: I would like to replace a formula to the actual text of the formula. Fo E.G. if I have in a cell "=A1", and I want to copy the formula to cell A25, it will copy it like this, "=A25", but I want it to copy exactly like the formula, "=A1". So how can I replace the formula in a cell to the actual text of the formula without using a formula. Hope I'm explaining myself well, If not ask please I'll explaine myself more. I need help on this. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace text with formula | Excel Discussion (Misc queries) | |||
Can I replace a ' at the beginning of a text cell using Replace | Excel Discussion (Misc queries) | |||
How do I replace text within a formula with a diff cell value? | Excel Worksheet Functions | |||
How do I replace my vlookup FORMULA with just the TEXT of results | Excel Worksheet Functions | |||
find text in cell and replace it with part of the text in that ce. | Excel Discussion (Misc queries) |