LEN Formula comes handy when you need to get the length of text. Sometimes you boss wanted to know the length of the text of some serial codes, names, etc. Then you may count each and every word as a traditional method.
What if I tell you that there’s LEN Formula in excel which works like magic in a matter of few inputs? Sounds exciting right?
Let’s get started then!
We have the following weird-looking serial code sheet which we will use to get the length of text.
STEP1: Working With LEN Function
Enter the LEN function next to the SERIAL column to determine the length of the text.
Now we will add the ‘text’ value of A2 as follows;
Now we will get the length of the particular serial code.
STEP2: Apply to All
Now, we will apply to all serial code values to just by dragging cell to bottom.