How to use the LEN Function in Excel

The LEN function in Excel counts characters in a string. I mainly use it when I need to extract text from a string. The Excel LEN function comes in handy when the number of characters in a string is indefinite.

Excel LEN Function Syntax

=LEN(string)

String : this can be a hardcoded string or a cell reference.

LEN function does not discriminate between the numbers and texts. It counts spaces too.

Example of LEN Function

Count length of “Mahishmati”. Yes of course, count of the characters.

LEN Formula to count number of characters in a string

=LEN(“Mahishmati”)

The length of string is 10.

Now lets count the number of characters of string in cell B2. B2 can change any time.

=LEN(B2)

This will return the count of characters in cell B2 (not of the formula but value).

So yeah guys. Thats what LEN function do. It might not sound attractive but when it is used with other string function like LEFT, RIGHT, SUBSTITUTE, FIND, SEARCH, it works as a trigger of a missile. You can check my articles on Text extraction and how LEN function helped me hit the target.

Related Articles:

Extract Text From A String In Excel Using Excel’s LEFT And RIGHT Function

Excel Formula to Extract Unique Values From a List

Remove first characters from text

Popular Articles:

50 Excel Shortcuts to Increase Your Productivity

How to use the VLOOKUP Function in Excel

How to use the COUNTIF function in Excel 2016

How to Use SUMIF Function in Excel

 

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.