How to get middle characters of cell in Excel | Use of MID function (formula) in Excel

MID

Use of MID Function / Formula of MID Function in Excel

MID formula/Function helps to return specific number of characters in particular cell.
It extract character at the position you specify in formula.

Syntax/Formula of MID function in Excel

The syntax of MID function in Microsoft Excel is below.

=MID(text,start_num,num-chars)

Example of MID Function in Excel

Step 1: First type ADVANCEDMSEXCEL.BLOGSPOT.COM in cell B4 as per shown in below image.

Step 2: Type formula =MID(B4,9,2) in cell B6 and press enter.

MID FUNCTION