MID function in Excel

Syntax

=MID(text, start_num, num_chars)

Example

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

From the lesson MID Function.

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.

Related text functions

• LENReturns the number of characters.
• LEFTReturns characters from the start of the text.
• RIGHTReturns characters from the end of the text.
• FINDCase-sensitive position of text within text.
• SEARCHCase-insensitive position of text; supports wildcards.
• CONCATJoins text from cells and ranges.
• CONCATENATEJoins text items (legacy).
• TEXTJOINJoins text with a delimiter.