- Formula Reference
- Contacting Us
- Getting Technical Support
- Formula Overview
-
Formula Functions
- Functions A to C
- Functions D to G
- Functions H to L
- Functions M to Q
- Functions R to S
-
Functions T to Z
- T
- T.DIST
- T.DIST.2T
- T.DIST.RT
- T.INV
- T.INV.2T
- T.TEST
- TAKE
- TAN
- TANH
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- TDIST
- TEXT
- TEXTAFTER
- TEXTBEFORE
- TEXTJOIN
- TEXTSPLIT
- TIME
- TIMEVALUE
- TINV
- TOCOL
- TODAY
- TOROW
- TRANSPOSE
- TREND
- TRIM
- TRIMMEAN
- TRUE
- TRUNC
- TTEST
- TYPE
- UNICHAR
- UNICODE
- UNIQUE
- UPPER
- USDOLLAR
- VALUE
- VALUETOTEXT
- VAR
- VAR.P
- VAR.S
- VARA
- VARISPARKLINE
- VARP
- VARPA
- VBARSPARKLINE
- VDB
- VLOOKUP
- VSTACK
- WEBSERVICE
- WEEKDAY
- WEEKNUM
- WEIBULL
- WEIBULL.DIST
- WINLOSSSPARKLINE
- WORKDAY
- WORKDAY.INTL
- WRAPCOLS
- WRAPROWS
- XIRR
- XLOOKUP
- XMATCH
- XNPV
- XOR
- YEAR
- YEARFRAC
- YEARSPARKLINE
- YIELD
- YIELDDISC
- YIELDMAT
- Z.TEST
- ZTEST
TRIM
This function removes extra spaces from a string and leaves single spaces between words.
Syntax
TRIM(text)
Arguments
The argument specifies the string containing the spaces you want to remove.
Data Types
Accepts string data. Returns string data.
Examples
TRIM("First Quarter") gives the result First Quarter
Version Available
This function is available in product version 1.0 or later.