Extract Text using MID

Pull characters from the middle of a string.

You will learn to

  • Use a start position and length

How it works

MID(text, start_num, num_chars) returns characters from the middle. =MID(A2,4,4) starts at character 4 and returns 4 characters: "2024".

=MID(A2,4,4)