Excel Tricks with Tejraj

In this blog post we will learn about MID function in excel. MID function returns number of characters from middle of the text string, given starting position and text length. Where to find MID function on Excel Screen: MID function can be found under “Text Function” category under “Formula Tab” as shown in below image: Once we click on “Text” category, we can see list of various Text Functions available in excel. MID function is highlighted in red in below image. Once we click on MID option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of MID Function: The Syntax of MID function is as below: =MID(text, start_num, num_chars) Arguments of MID Function: To use the MID function we have to use 03 arguments: Text : In this, we have to select the text from which we have to extract the characters. Start Num : It is position of first character you want to extract. The first character in text is 1. Num_chars : Specifies how many characters to...