Function LEN()

 

Description
Returns the length of a string (including spaces) or the number of items in an array.

Syntax

LEN(string)

LEN(array)

 

Parameters

• string/array – The string or array to measure

Return Value
NUMBER

Examples

Formula

LEN("SharpCloud")

Result
10

Formula

LEN("SharpCloud Software")

Result
19

Formula

LEN(["Low", "Med", "High"])

Result
3

Formula

LEN([1,2,3,4,5])

Result
5

Notes

• Counts spaces in strings
• Counts total elements in arrays