Excel MID() Function

The MID() function in excel is used to return a specific number of characters from a text string starting at the position you specify. One can change the start of the string, thus making MID function different from the LEFT function.

Syntax

MID(Text, [starting_position], [num_chars])

Parameter

Text (required)- This parameter represents the string from which you want to find letters.

starting_position(optional)- This parameter represents the starting position of the string.

num_chars(optional)- This parameter represents the number of characters you want to read from the starting of the string.

Category

Text

Return

This function returns the number of specified characters from the left to right wherein you can change or alter the start position of the string.

Example 1

Objective: Use MID function on the following strings

Text	Result	Formula
Laptop restarted	top re	=MID(A22,4,6)
EXCEL IS WOW	XCEL IS W	=MID(A23,2,9)
SUPERSTORE IS CLOSED	E IS CLOS	=MID(A24,10,9)
90 EMPLOYEES	0 EMPL	=MID(A25,2,6)

Example 2

Objective: Use MID function on the following strings

Name	Middle Name	Formula Used
Sukla Rani Pati	ani P	=MID(B8,8,5)
Rachel Buffay	Buffa	=MID(B9,8,5)
Joey Mitchell	Tchel	=MID(B10,8,5)
Chandler Kumar Patra	r Kum	=MID(B11,8,5)
Delia Azahari	Zahar	=MID(B12,8,5)
Mar Martin Castellano	tin C	=MID(B13,8,5)
Daniel Oso	Oso	=MID(B14,8,5)
Aman Singh Bhardwaj	ngh B	=MID(B15,8,5)
Kriya Bhansali	Hansa	=MID(B16,8,5)
Monica Bantónio	Bantó	=MID(B17,8,5)