The LEN function returns the length of the specified string.
=LEN(text)
text is the string to return the length for.
EXAMPLE:
=LEN(word) will return the value of 4.
The Insert Function dialog box.
Click on the function bar at the top of the worksheet (looks like fx).
The Insert Function dialog box contains a list of predefined functions available in Excel. Click the Insert Function box, and in the search bar, type in a description of what you want to do. Click OK, and then browse through the functions. If you already know the name of a function, choose it from the box.
It is a function
The LEN function counts the amount of characters in a cell. For example: =LEN(A3)
You use the LEN function. Say you had some text in cell A2 and you wanted to find out how long it was, then you would type the following formula: =LEN(A2)
style
Use the LEN function to count how many characters are in the cell. If you want to evaluate cell C23, use LEN(C23)=6.
Guess you meant: can a recursive function call predefined functions? Answer: sure, why not.
Formatting.
Predefined functions are built-in functions that perform standard operations and that generally do not depend on any classes. A predefined void function is simply a predefined function that has no return value. An example of a predefined void function is the abort() function which typically has the following signature: void abort(void);
LEN will count spaces in a cell as well as other characters. So there is no special way needed to count spaces as they will be included. If you are counting what is in cell A3 for example, then you would use the function: =LEN(A3) To count only the spaces in a cell and ignoring other characters, then you could try this approach: =LEN(A3)-LEN(SUBSTITUTE(A3," ","")) It gets the full length and then substracts the length of the text with the spaces removed.