0
0
Excelspreadsheet~10 mins

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

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
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.