The LEN function gets the number of characters in a text.
Because it is faster and more accurate than counting by eye, it has a great effect by itself and is a useful function with a wide range of applications.
How it works
=LEN(string)
Name
Omission
Specify
string
Required argument.
Text that counts the number of characters.
Demonstrate
Both one-byte and two-byte characters are counted as one character.
Control characters are also counted as a single character. Therefore, if there is a line break in a cell, it is also counted as one character.
Spill
If the argument were a cell range, it would be Spill.
---
Links
Microsoft Excel Functions Text
Examples of Use
Formulas to randomly reorder a range of cells.
Formulas to extract text from a cell every specified number of letters.
Formulas to sort text in cells.
Formula to split text into cells one character at a time.
How to reverse text.
How to extract only numbers from text.
Formula for extracting URL parameter values.
Formula to remove URL parameters or only URL parameters.
How to display file and sheet names in cells.
How to change the cell color to detect when a certain number of characters are exceeded.
Formulas to search from with the FIND function.
Formula to find out how many strings are contained.
Formulas to extract characters before, after, or between specific strings.
Formula to search for line break in a cell with the FIND function.