Question

state the use of len function give examples​

Answer 1

Answer:

This is your answer.....

Explanation:

follow me...........

Answer 2

Answer:

LEN function is a text function in excel that returns the length of a string/ text.

LEN Function in Excel can be used to count the number of characters in a text string and able to count letters, numbers, special characters, non-printable characters, and all spaces from an excel cell. In simple words, LENGTH Function is used to calculate the length of a text in an excel cell.

Explanation:

Example: LEN function is a text function in excel that returns the length of a string/ text.

LEN Function in Excel can be used to count the number of characters in a text string and able to count letters, numbers, special characters, non-printable characters, and all spaces from an excel cell. In simple words, LENGTH Function is used to calculate the length of a text in an excel cell.

The length of 1035 miles is 9. To get the number of characters to extract, we subtracted 6, which is the length of " miles " ( including the space character). The result is 4, which is fed to extract .LEFT then returns the text " 1035 " as a yext value.