When working with Excel, you may wonder about the length of each cell in some columns. Actually, you can easily count that by using the LEN function, which returns the number of characters in a text string.
Example: In the following database, the first name is in column A, the last name is in column B, and the email address is in column C.
Formula: To count the length of email addresses.
=LEN(C2)
Type the formula of "=LEN(C2)" in one cell, and drag down the end to get the length for all cells. For example, C2 includes 23 characters, and it will return 23.
Notes: The LEN Function
The LEN function returns the number of characters in a text string.
Formula:
=LEN(text)
Explanations:
– The text whose length you want to find, and spaces count as characters.
