LEN is an excel formula that is used to count the character length in a cell. It can be used to count numbers/texts in given cells.
Formula: =LEN(text)
Below is an example:
In the example, the LEN formula is being used to count the number of characters present in the cell. As you can see we have a total number of characters in B2.