How to Use Excel LEN Function?

Ads

Listen to this article

LEN Function in Excel: Microsoft Excel is a powerful utility that allows you to manage and maintain huge data on a spreadsheet. It offers more number of built-in functions and formulas for performing mathematical operations which are difficult to do manually. On that note, we can use this LEN Function in the Excel worksheet to find out the length of the given data.

The word length is abbreviated as LEN. Usually, the length is a measure of distance. We can find the height or width of the specific thing with this measurement. In Excel, sometimes we want to count the characters that are appeared in a specific cell, and doing it manually is a bit challenging. To find the length of the string or given value on your spreadsheet, then you need to use the LEN function to get the length.

In this post, we give you an explanation, basic syntax, and usage of the LEN function in Excel. Get the official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

Description of LEN Function

LEN is one of the built-in functions provided by Microsoft Excel. And you can use this function to find the length of the given text string on the spreadsheet.
The LEN Function in Excel returns the length based on the given text string.
LEN will also count characters in numbers, symbols, and also mathematical characters.
If you give any space or comma in the value, it will be counted.
It also counts the decimal points and negative symbols.
In case, you apply any formatting to the data, it will count the digits only and exclude the formatting.

Syntax

Here, you will see the syntax of the LEN Function.
To apply this LEN function on your spreadsheet, you have to select a cell and enter the formula in the following format.
Once you enter the formula, just click on the Enter button to get the length of the text.

=LEN(text)

Argument Description

This function has only one argument, which is your input data.
Text – The text or any character for which to calculate length.

Practical Examples

Now Let’s grasp some examples of the LEN function and explore how it works in Microsoft Excel.

Step 1: Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
Step 2: For example, we enter the following data in a spreadsheet in a range B3:B5.

Step 3: In this data, we have only given an array of alphabets and numbers to find out the length of the data.
Step 4: For that, we enter the above-given formula in Cell D3, D4 & D5 and click on the Enter button.

Step 5: Now, you will get the total length of the given data, as shown in the below screenshot.

Step 6: Let’s see another example to understand the LEN function more clearly.
Step 7: In the following screenshot, you can see the set of input values which includes decimal points, commas, spaces, and negative symbols.

Step 8: As we said already, these kinds of input values can be counted as the length in Excel.
Step 9: We can apply the formula and get the length of the given input values, as shown in the below image.

Closure

In this post, we have learned how to use LEN Function in Excel with proper explanation, syntax, and some practical examples. So, you can apply this LEN function on your worksheet to get the length of the given data as quickly as possible.

We hope that this post might be helpful to you. Let us know what you think!. If you want to learn more about Excel functions, then visit our webpage Aawexcel.com.

Read Also:

Keshav