Returns the length of a string.
text- The string whose length will be returned.
LENcounts all characters, even spaces and nonprinting characters. In cases where
LENreturns unexpected values, ensure that there are no such characters in
LEFT: Returns a substring from the beginning of a specified string.
RIGHT: Returns a substring from the end of a specified string.
MID: Returns a segment of a string.
In order to use the LEN formula, start with your edited Excellentable:
Then type in the LEN formula in the area you would like to display the outcome:
By adding the values you would like to calculate the LEN formula for, Excellentable will generate the outcome: