Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

Lesson 1/6

LEN: count characters

Exercise 1 of 3

In B2, count the characters in Ana's name.

About this lesson

LEN counts the characters in a text, spaces included, which helps when you check codes and length limits.

In this lesson

  1. In B2, count the characters in Ana's name.
  2. Valid codes are exactly 10 characters long. In B4, check whether the code in A4 is valid.
  3. A message can be at most 30 characters long. In B2, work out how many characters are left for the message in A2.

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Type in B2 and press Enter to check.