MID Function

Freebeginner 15 min4 tasks0/60 pts

MID returns characters from the middle of text. Tell it where to start (the first character is 1) and how many characters to take. It is the tool for pulling a year, an ID number or a code out of a longer value.

Syntax

MID(text, start_num, num_chars)

Example: =MID("INV-2024-0371",5,4) starts at character 5 and takes 4, giving 2024.

Common mistakes

Counting from 0: the first character is position 1.
MID always returns text. Multiply by 1 (or use VALUE) if you need a number.

LEN, LEFT, and RIGHT Functions LEN, LEFT, RIGHT, MID Practice