6th class Computer, State the use of LEN function. Give example.

Question. State the use of LEN function. Give example.

Ans. The LEN Function is categorized under Excel TEXT functions. The function will return the length of a given text string.

In financial analysis, the LEN function can be useful if we wish to get the length of a given text string as the number of characters. LEN will also count characters in numbers, but number formatting is not included.

Formula

=LEN(text)

The LEN function uses only one argument:

1. Text (required argument) – This is the text for which we wish to calculate the length. We can provide the text argument for the function:

• Directly
• As a string returned from another formula
• As a reference to a cell containing a string

Example 1

Let’s see how we can test a few conditions. Suppose we are given the following values.

We will get the result below :

In the examples above:

1. Spaces are counted as characters. Hence, the function returned 13 for the first argument.
2. The length of the empty string is 0.