Which function is used to find the number of characters in a text string in Excel?

a) CHAR

b) LENGTH

c) COUNT

d) TEXTLEN

Show Answer

b) LENGTH

In Excel, the function used to find the number of characters in a text string is the LEN function. The LEN function returns the length of a text string, which is the count of characters in the string, including letters, numbers, symbols, and spaces.