Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Textualize" another cell's formula
Hi all,
Is there a way to "Textualize" a forumula from another cell usinig standard Excel built-in text functions? For example A1 B1 C1 D1 1 2 3 [A1+B1] cell D1 gets it's value from C1 which contains a formula: [=A1+B1]. But in D1 the "=" is stripped. Thanks. Ben -- |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Textualize" another cell's formula
Here is a user-defined function that will do what you want
Function showfn(mycell) If mycell.HasFormula Then showfn = Mid(mycell.Formula, 2) Else showfn = "" End If End Function Need help using it? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Ben" wrote in message ... Hi all, Is there a way to "Textualize" a forumula from another cell usinig standard Excel built-in text functions? For example A1 B1 C1 D1 1 2 3 [A1+B1] cell D1 gets it's value from C1 which contains a formula: [=A1+B1]. But in D1 the "=" is stripped. Thanks. Ben -- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Textualize" another cell's formula
You can also put an apostrophe to the left of the formula you're entering if
you want the = sign to remain visible. -- Brevity is the soul of wit. "Bernard Liengme" wrote: Here is a user-defined function that will do what you want Function showfn(mycell) If mycell.HasFormula Then showfn = Mid(mycell.Formula, 2) Else showfn = "" End If End Function Need help using it? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Ben" wrote in message ... Hi all, Is there a way to "Textualize" a forumula from another cell usinig standard Excel built-in text functions? For example A1 B1 C1 D1 1 2 3 [A1+B1] cell D1 gets it's value from C1 which contains a formula: [=A1+B1]. But in D1 the "=" is stripped. Thanks. Ben -- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Textualize" another cell's formula
Bernard,
Thanks for below function. Is there a way to do it using just standard Excel function, ie, entering Excel formula in the formula bar? Ben -- "Bernard Liengme" wrote: Here is a user-defined function that will do what you want Function showfn(mycell) If mycell.HasFormula Then showfn = Mid(mycell.Formula, 2) Else showfn = "" End If End Function Need help using it? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Ben" wrote in message ... Hi all, Is there a way to "Textualize" a forumula from another cell usinig standard Excel built-in text functions? For example A1 B1 C1 D1 1 2 3 [A1+B1] cell D1 gets it's value from C1 which contains a formula: [=A1+B1]. But in D1 the "=" is stripped. Thanks. Ben -- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Textualize" another cell's formula
Not really using a "standard" XL function ... but this *is* using an XL
function in a named formula. ****************** First, the CAVEAT: This should be used in XL02 and later. Earlier version *WILL* crash when *copying* this formula to other WBs. Can be used in all versions as long as you don't copy to *Other* WBs ... copying within a sheet is OK. *********************** Start by clicking in D1, then, <Insert <Name <Define In the "Names In Workbook" box, enter a short name for this formula, say displ for "display". In the "Refers To" box, replace whatever's there with this formula: =GET.CELL(6,C1) Then <OK What you have now is a 'relative' *named formula* that when entered in *any* cell, will return the contents of the cell (text, data, formulas) from the *previous* column. So, if you enter, =displ in D1, you'll see the formula from C1 displayed. =A1+B1 You stated in your OP that you wanted to see the formula without the equal sign. If you *really* want to strip the = sign, then use this formula in D1: =RIGHT(displ,LEN(displ)-1) You can copy this down as needed, if you wish. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ben" wrote in message ... Bernard, Thanks for below function. Is there a way to do it using just standard Excel function, ie, entering Excel formula in the formula bar? Ben -- "Bernard Liengme" wrote: Here is a user-defined function that will do what you want Function showfn(mycell) If mycell.HasFormula Then showfn = Mid(mycell.Formula, 2) Else showfn = "" End If End Function Need help using it? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Ben" wrote in message ... Hi all, Is there a way to "Textualize" a forumula from another cell usinig standard Excel built-in text functions? For example A1 B1 C1 D1 1 2 3 [A1+B1] cell D1 gets it's value from C1 which contains a formula: [=A1+B1]. But in D1 the "=" is stripped. Thanks. Ben -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
Formula works in some cells, doesn't in other | New Users to Excel | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) |