Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referring To Contents Of Formula
Any idea how to refer to/use the contents of a formula in one cell in another
formula? For example you can type a formula like: =Left(A1,5) Now, suppose if cell A1 contains a formula like =Sum(... ... ...) How, to get the first five characters of the formula existing in A1, i.e. "=SUM(" ? -- Best Regards, FARAZ A. QURESHI |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referring To Contents Of Formula
On Fri, 16 Jan 2009 21:52:01 -0800, FARAZ QURESHI
wrote: Any idea how to refer to/use the contents of a formula in one cell in another formula? For example you can type a formula like: =Left(A1,5) Now, suppose if cell A1 contains a formula like =Sum(... ... ...) How, to get the first five characters of the formula existing in A1, i.e. "=SUM(" ? I don't think this can be done without using VBA. Try the following User Defined Function: Function get_formula(r As Range) get_formula = r.Formula End Function The you can use it in a formula like =LEFT(get_formula(A1),5) Hope this helps / Lars-Åke |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referring To Contents Of Formula
This old post should help:
http://tinyurl.com/46af9t -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "FARAZ QURESHI" wrote in message ... Any idea how to refer to/use the contents of a formula in one cell in another formula? For example you can type a formula like: =Left(A1,5) Now, suppose if cell A1 contains a formula like =Sum(... ... ...) How, to get the first five characters of the formula existing in A1, i.e. "=SUM(" ? -- Best Regards, FARAZ A. QURESHI |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using the drag down function and formula referring to other worksh | Excel Discussion (Misc queries) | |||
Referring to Sheet locations in a formula | Excel Worksheet Functions | |||
Formula referring to a dynamic range in a different workbook | Excel Worksheet Functions | |||
Formula referring to a different sheet | Excel Discussion (Misc queries) | |||
formula works when referring to one cell but not to another | New Users to Excel |