1. Spreadsheet.com Support
  2. Functions
  3. Text functions

LEN

Returns the length of a string, including spaces.

Sample Usage

LEN("spreadsheet")
LEN(C5)

Syntax

LEN(text)

  • text - The text whose length is to be determined. 

 

Examples

LEN("spreadsheet") returns the length - 11.  
LEN(C5) returns the length of the string in C5.

Notes

  • Spaces and non-printable characters are also counted.