LEN practice

LEN returns the number of characters in a text. Below are the 1 Google Sheets exercise on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

LEN(text)

What people get wrong

LEN is how you check a code is the right length, or find text with stray spaces by comparing LEN(TRIM(x)) with LEN(x).

Google Sheets exercise that use LEN

• Codes that are too longLevel 4Pro

Often used together with: ARRAYFORMULA, IF, SUM