The LEN function can be used in either a string or array setting and is used to return the length (number of characters including spaces) of a string or the count of items in an array.


LEN(x) or LEN([x])


x = The string or array that you want to return the length of.

Data Type Returned

Will return a number.


LEN(“SharpCloud”) will return the value of 10.

LEN(“SharpCloud Software”) will return the value of 19.

LEN([“Low”, “Med”, “High”]) will return the value of 3.

LEN([1,2,3,4,5]) will return the value of 5.