0
0
Excelspreadsheet~10 mins

LEN function in Excel - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
Sample Data

This data shows different text strings in cells A1 to A5. Some are words, some numbers as text, a space, and an empty cell.

CellValue
A1Hello
A2Excel
A312345
A4
A5
Formula Trace
=LEN(A1)
Step 1: A1
Step 2: LEN("Hello")
Cell Reference Map
Hello
Excel
12345
The formula references cell A1 which contains the text 'Hello'.
Result
Hello
Excel
12345
The LEN formula in B1 returns 5, the length of the text in A1.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does LEN(A1) return if A1 contains 'Hello'?
A6
B4
C5
DError
Key Result
LEN(text) returns the number of characters in the text string including spaces.