What is the Microsoft Excel “LEN” function used for?
- it returns the number of characters in a text string in a cell
- it automatically adds the values in a given range
- it searches for blank cells in a given column
- it sorts values in a given column
| Answers Explanation & Hints:
The “LEN” function is used to return the number of characters in a text string. Please note that any spaces in the text string will be considered as a character and counted as such. |