LEN function returns the number of characters in a text string. Spaces will also be counted as characters.
GrammarLEN(text)
Text is the text whose length is to be found.
The function of the LEN function is to return the number of characters in a text string.
It is a text function, suitable for occasions where the text length needs to be judged. Using this function, you can get results quickly and accurately.
Different from the LENB function, the LEN function counts the number of characters, whether it is Chinese characters or English characters, including spaces, each character is counted as 1.
The following is an example of how to use the LEN function:
First, click Insert Function in cell B4 and select the LEN function under the Text category.
A dialog box will pop up, asking to enter a parameter.
"String" refers to the string whose length needs to be calculated, and the spaces contained in it will also be counted in the number of characters.
Enter the reference to cell B3 in the "String" parameter and click OK to get the total number of characters in the text.
评论列表(196条)
测试