Skip to content

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

Lesson 3/6

MID: text from the middle

Exercise 1 of 3

In B2, take the 4-digit number from the middle of the code.

About this lesson

MID takes characters from the middle of a text, starting at a position you choose.

In this lesson

  1. In B2, take the 4-digit number from the middle of the code.
  2. Do the same for the code in A3, in B3.
  3. In B2, take the month from the date written as text.

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.