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)



ADVERTISEMENT
ADVERTISEMENT