Google Sheets Function: MID

The MID function returns a segment of a string based on the start character and the number of characters to extract.


=MID(string, starting_at, extract_length)

Usage Example

The MID function here needs to extract the 4-digit number in the middle of the reference:

google sheets mid function

Enter into the MID function:

Therefore, the formula is:

google sheets mid function extraction