LEN

While this may sound like someone’s first name it’s also a function within Microsoft Excel. This function counts the number of characters in a string of text. Keep in mind that spaces count as characters as well. This function can be used to clean up data if used in conjunction with a few others.

1. Above are three examples of characters entered in cells.

2. The syntax for the function is =LEN (Cell_Address)

3. The function reveals the number of characters for each example