**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:**

- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?