Length()

Working with Formulas > Functions Used in Formulas > Text Functions > Length()

LENGTH() returns the number of characters in a specified string, including any leading or trailing blanks.

NOTE: If you do not want LENGTH() to count leading or trailing blank spaces, use the TRIM() function to remove these characters.

Function Format

LENGTH(string) 

Return Value

LENGTH() returns an integer value 

Examples

LENGTH("APPLES") = 6 

LENGTH(" APPLES ") = 8 

LENGTH(TRIM(" APPLES ")) = 6