SUBSTITUTE
TEXT
About This Document
The Gnumeric Manual, version 1.12
Welcome!
How to Use This Manual
A Quick Introduction
Gnumeric Elements
Working with Data
Advanced Analysis
The Solver
Statistical Analysis
Graphics: Images, Widgets, and Drawings
Graphs
Using Worksheets
Workbook Settings
Configuring Gnumeric
Working with Files
Printing
Getting More Help
Reporting a Problem
Extending Gnumeric
Function Reference
Bitwise Operations
Complex
Database
Date/Time
Engineering
Erlang
Finance
Gnumeric
Information
Logic
Lookup
Mathematics
Number Theory
Random Numbers
Statistics
String
ASC
CHAR
CLEAN
CODE
CONCATENATE
DOLLAR
EXACT
FIND
FINDB
FIXED
JIS
LEFT
LEFTB
LEN
LENB
LOWER
MID
MIDB
NUMBERVALUE
PROPER
REPLACE
REPLACEB
REPT
RIGHT
RIGHTB
SEARCH
SEARCHB
SUBSTITUTE
T
TEXT
TRIM
UNICHAR
UNICODE
UPPER
VALUE
Time Series Analysis
Keybinding Reference
T
The Gnumeric Manual, version 1.12
Function Reference
String
T
—
value
if and only if
value
is text, otherwise empty
Synopsis
Arguments
Microsoft Excel Compatibility
See also
Synopsis
T
(
value
)
Arguments
value
: original value
Microsoft Excel Compatibility
This function is Excel compatible.
See also
CELL
,
N
,
VALUE
.
SUBSTITUTE
TEXT