Shulou(Shulou.com)06/02 Report--

Editor to share with you what are the functions of the len () function, I hope you will gain something after reading this article, let's discuss it together!

The function of len () is to return the number of characters in the text string in the specified cell, which is used as follows: first open the excel table; then select the [len] function and click [OK]; then select the cell you want to use the len function; and finally click [OK] to return the number of characters in the string in the selected cell.

Methods:

The len function in excel returns the number of characters in the text string in the specified cell. The specific steps are as follows:

1. After opening the excel table, in the ribbon, select other functions in the function.

Note: len function is not a commonly used function, the commonly used functions are summation, average and so on.

2. After selecting the [len] function, click OK.

3. Select the cell that you want to use the len function.

4. After the selection is completed, click OK to return the number of characters in the string in the selected cell.

For example, "the cool of sitting and thinking" is 7 characters.

5. If you need to count the number of characters in the entire column of data, you can click on the square in the lower right corner of the cell that has been set up for the function, and drag down.

6. Complete the filling of the function and return the number of cell characters counted.

After reading this article, I believe you have a certain understanding of "what are the functions of the len () function". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.