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.


Syntax


LEN(x) or LEN([x])


Parameters


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


Data Type Returned


Will return a number.


Examples


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.