LEN practice

LEN returns the number of characters in a text. Below are the 1 Excel exercise on Formuladrill 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).

Excel exercise that use LEN

• Pull out the domainLevel 4Pro

Often used together with: FIND, MID