ƒxPlainFormulaThink in English. Formula in Excel.

FUNCTION CATALOGUE / TEXT

MID Excel function

Extracts text from a specified position.

Correct sentence to use

Extract [number] characters from [text], starting at position [start].

Modify this query in PlainFormula →

Example formula

=MID(A2,2,5)

Returns a substring.

Syntax

MID(text, start_num, num_chars)

Argument signature: text, start_num, num_chars

Availability note

Commonly available in current Excel; verify platform and locale-specific behaviour.

Check Microsoft's Excel function documentation ↗

← Browse all functions