Microsoft Office Tutorials and References
In Depth Information
T
SUBSTITUTE function in the first example uses complete cell referencing from one cell to
another. The second example gives a mix of cell referencing and text directly in the formula.
For the formula =SUBSTITUTE(“Melrose”,C11,”Farming”) , where Cll equals Melrose, the
result is Farming.
This is the text or text in a cell you want to substitute.
TEXT
This is the text you want to replace.
OLD_TEXT
This is the new text to replace the old text with.
NEW_TEXT
This is the number of instances you want to replace the old text
with. For example, if you want to replace ever y occurrence of old
text, use “][“. If replacing just one occurrence, use 1.
INSTANCE_NUM
Figure 12.11
The SUBSTITUTE
function replaces one
text string or cell for
another.
A
Substitutes
one name… B
…for another name.
T T returns the text referred to by VALUE .
=T(value)
The T function is provided for compatibility with other spreadsheet programs. Microsoft Excel
automatically converts values as necessar y. For example, the formula =T(“Bob”) would result
in Bob.
The value is the text or value using a cell reference you want to test. If
value is a number, T returns nothing or empty text.
VALUE
TEX The TEXT function converts a value to text in a specific number format.
=TEXT(value,format_text)
Search JabSto ::




Custom Search