LEN function

CALC FUNCTIONS

Text Functions

< Previous Section

Next Section >

FUNCTIONS

• ARABIC
• ASC
• BASE
• BAHTTEXT
• CHAR
• CLEAN
• CODE
• CONCATENATE
• DECIMAL
• DOLLAR
• EXACT
• FIND
• FIXED
• JIS
• LEFT
• LEN
• LOWER
• MID
• PROPER
• REPLACE
• REPT
• RIGHT
• ROMAN
• SEARCH
• SUBSTITUTE
• T
• TEXT
• TRIM
• UNICHAR
• UNICODE
• UPPER
• VALUE

< Previous Page

Next Page >

LEN

Returns the length of a text string.

Syntax:

LEN(text)

returns the number of characters in the text text, including spaces.

Example:

LEN("red car")

returns 7.

LEN(123.4)

returns 5 (numbers are converted to text).

---

See Also

• LEFT
• RIGHT
• MID

• Text functions

• Functions listed alphabetically
• Functions listed by category