The LEN function in Excel counts characters in a string. I mainly use it when I need to extract text from a string. The Excel LEN function comes in handy when the number of characters in a string is indefinite.
The LEN function syntax has the following arguments:
- text – The text for which to calculate length.
Example: Let’s look at some Excel LEN function examples and explore how to use the LEN function as a worksheet function in Microsoft Excel: