4D Online Documentation Center

4D v18

LEN

4D View Pro Reference
- 4D View Pro Formulas
- - Operators and values
  - Cell references
  - Converting 4D View plug-in formulas
  - ABS
  - ACOS
  - AND
  - ASIN
  - ATAN
  - AVERAGE
  - COLUMNLETTER
  - COS
  - COUNTA
  - EXP
  - FALSE
  - FINDCELL
  - FV
  - IF
  - INDIRECT
  - ISBLANK
  - LEN
  - LN
  - LOOKUP
  - MAX
  - MID
  - MIN
  - NOT
  - NOW
  - NPER
  - OR
  - PI
  - PMT
  - PV
  - RAND
  - RATE
  - ROUND
  - ROW
  - RUNTIME_CURRENT_TIME
  - RUNTIME_DATE
  - RUNTIME_STRING
  - RUNTIME_TIME
  - RUNTIME_VIEW_STRING
  - SIN
  - SQRT
  - STDEV.P
  - SUBSTITUTE
  - SUM
  - TAN
  - TEXT
  - TODAY
  - TRUE
  - TYPE
  - VAR.P

Home

4D v18

4D View Pro Reference

4D View Pro Formulas

LEN

LEN


	LEN ( value )

	Parameter		Type				Description
	value		Text, CellRef				Text whose character length to count

Description

The LEN function returns the number of characters in the value string.

In value, pass the text whose length you want to find. It must be a string or a cell reference to a string value.

Note: Spaces count as characters

Example

LEN("4D, Inc.") //8

Previous page

Next page

PROPERTIES

Product: 4D
Theme: 4D View Pro Formulas

HISTORY

ARTICLE USAGE

4D View Pro Reference ( 4D v18)

© 1985-2020 4D SAS / 4D, Inc. All rights reserved.

Add a comment