The Len Function
The LEN function returns the number of characters in the text strings.
Syntax:
LEN(text)
Parameters:
- Text: The text we want to know the length
Example:
Step 1: Format your data.
Now if you want to know how many characters are in the text “w3wiki”. Let us follow the next step.
Step 2: We will enter =LEN(B2) in the B3 cell. Excel will count how many characters are in the text.
This will return 13.
Excel String Functions – LEFT, RIGHT, MID, LEN, and FIND
Excel is mostly about numerical, however, we often have data of text data type. Here are a few functions we should know to handle text data.
- LEFT
- RIGHT
- MID
- LEN
- FIND