LEN returns the number of characters in a text string.
Syntax
LEN(text)
Text is the text whose length you want to find. Spaces will be counted as characters.
LEN function is to return the number of characters in the text string .
It is a text function. When we need to determine the length of text, using this function is very fast and accurate.
The difference from the LENB function is that the LEN function is calculated based on the number of characters. Both Chinese and English characters, including spaces, are counted as 1.
The following shows you how to use this function.
￭First, position the cursor at B4 and click Insert Function-Text-LEN Function.
A dialog box will pop up with one parameter.
"String" refers to the string whose length needs to be calculated, including spaces.
￭Enter B3 in "String" and click OK to get the total number of characters of this text.
支付宝扫一扫 
评论列表（196条）
测试