Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedding text into formulae
Does anyone know how to embed text into a formulae? I have used this function
in a past life and connot recreate now. A very simple example would be:- =100(revenue)-25(m&s)=75(deferred) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedding text into formulae
Look at 'Define named cell references or ranges' in help . think that is
what you mean. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jo" wrote in message ... Does anyone know how to embed text into a formulae? I have used this function in a past life and connot recreate now. A very simple example would be:- =100(revenue)-25(m&s)=75(deferred) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedding text into formulae
I don't want to name ranges, I am looking to embed notes in functions. The
example below may make it clearer:- =100(need to confirm with Tom)-25(m&S starts Jan 1)=75(reconcile to defrred revenue) It's a way of seeing notes while working on a spreadsheet without having to have have lots of cell comments to refer to. "Bob Phillips" wrote: Look at 'Define named cell references or ranges' in help . think that is what you mean. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jo" wrote in message ... Does anyone know how to embed text into a formulae? I have used this function in a past life and connot recreate now. A very simple example would be:- =100(revenue)-25(m&s)=75(deferred) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedding text into formulae
Think you could embedd it using: +N("your text")
Eg: if you have in C1: =A1-B1 you could embedd the notes in C1 as: =A1 +N("need to confirm with Tom") - B1 +N("m&S starts Jan 1") or like this in C1: =A1-B1 +N("A1: need to confirm with Tom, B1: m&S starts Jan 1") My preference is for the latter which appears neater -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Jo" wrote: I don't want to name ranges, I am looking to embed notes in functions. The example below may make it clearer:- =100(need to confirm with Tom)-25(m&S starts Jan 1)=75(reconcile to defrred revenue) It's a way of seeing notes while working on a spreadsheet without having to have have lots of cell comments to refer to. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedding text into formulae
Thanks, that works perfectly
"Max" wrote: Think you could embedd it using: +N("your text") Eg: if you have in C1: =A1-B1 you could embedd the notes in C1 as: =A1 +N("need to confirm with Tom") - B1 +N("m&S starts Jan 1") or like this in C1: =A1-B1 +N("A1: need to confirm with Tom, B1: m&S starts Jan 1") My preference is for the latter which appears neater -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Jo" wrote: I don't want to name ranges, I am looking to embed notes in functions. The example below may make it clearer:- =100(need to confirm with Tom)-25(m&S starts Jan 1)=75(reconcile to defrred revenue) It's a way of seeing notes while working on a spreadsheet without having to have have lots of cell comments to refer to. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedding text into formulae
welcome, glad it helped.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Jo" wrote in message ... Thanks, that works perfectly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulae with Text | Excel Worksheet Functions | |||
fromatting formulae with text & dates | Excel Worksheet Functions | |||
Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
Embedding Images and/or Word Processor/Text Files in Excel | Excel Discussion (Misc queries) | |||
Embedding a reference in a cell with normal text. | Excel Worksheet Functions |