Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web

The LEN function is used to count the number of characters in a cell.

1. Select the cell where you want the result to display.

2. Type =LEN(text) where "text" is the cell that contains the text characters you want to count. For example, if A1 contains the text apple, then =LEN(A1) would return the number 5.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.