MID practice

MID returns a given number of characters from the middle of a text, starting at a position. Below are the 1 Excel exercise on Formuladrill that use it, each checked instantly in your browser.

Syntax

MID(text, starting_at, extract_length)

What people get wrong

Use a large length to take everything after a position.

Excel exercise that use MID

• Pull out the domainLevel 4Pro

Often used together with: FIND, LEN