Excel Function of the Month – LEN


The Excel Function of the month is

LEN

Description

The LEN function returns the number of characters in a string of text.

Usage

LEN counts the number of characters in a cell and returns that number. Below you can see where I have counted the number of characters in a sentence. Below that is an example where LEN can be used to visually check items for example, an ID number that is supposed to be 13 characters.

Check out my Excel posters for your classroom