Skip to content

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

Lesson 2/6

LEFT and RIGHT

Exercise 1 of 3

In B2, take the 2-letter prefix from the start of the code.

About this lesson

LEFT and RIGHT take a number of characters from the start or the end of a text.

In this lesson

  1. In B2, take the 2-letter prefix from the start of the code.
  2. In B2, take the 2-letter colour from the end of the code.
  3. In B2, take the year from the start of the invoice number.

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.