Kornilios Ampatzis/ April 19, 2019/ Functions

It returns the number of characters in a text string.

The syntax of the function is the following:

LEN(text)

text: The text whose length you want to find. Spaces count as characters.

Click on the button to practice using this function, with the help of our Online Assessment Tool:

Practice

Here is an example of how to use the LEN function:

In column B calculate the length of the words in column A.

Share this Post