0
0
Google Sheetsspreadsheet~10 mins

LEN function in Google Sheets - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
Sample Data

This data shows different text strings in column A, including words, a space, numbers as text, and an empty cell.

CellValue
A1Hello
A2World!
A3
A412345
A5
Formula Trace
=LEN(A2)
Step 1: A2
Step 2: LEN("World!")
Cell Reference Map
    A   
1 |Hello 
2 |World!<-- LEN uses this cell
3 |     
4 |12345 
5 |     
The LEN function references cell A2 which contains the text 'World!'.
Result
    A    |  B  
1 | Hello |     
2 | World!|  6  
3 |       |     
4 | 12345 |     
5 |       |     
The formula =LEN(A2) placed in cell B2 returns 6, the number of characters in 'World!'.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does LEN(A1) return if A1 contains 'Hello'?
A4
B5
C6
D0
Key Result
LEN(text) returns the number of characters in the given text, including spaces and punctuation.