Exceljet

Quick, clean, and to the point

Excel MID Function

Excel MID function
Summary 

The Excel MID function extracts a given number of characters from the middle of a supplied text string. For example, =MID("apple",2,3) returns "ppl".

Purpose 
Extract text from inside a string
Return value 
The characters extracted.
Syntax 
=MID (text, start_num, num_chars)
Arguments 
  • text - The text to extract from.
  • start_num - The location of the first character to extract.
  • num_chars - The number of characters to extract.
Version 
Usage notes 
  • MID returns a specific number of characters from a text string, starting at start_num and continuing through start_num + num_chars.
  • Use the MID function when you want to extract text from inside a text string, based on location and length.
  • You can use FIND or SEARCH to locate start_num when you don't know the location in advance.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.