Excel Tricks with Tejraj

In this blog post we will learn about CODE function in excel. With the help of CODE function we can get numeric code for the character. In case of text string, it will return numeric code for 1st character in text string. Where to find CODE function on Excel Screen: CODE 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. CODE function is highlighted in red in below image. Once we click on CODE option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of CODE Function: The Syntax of CODE function is as below: =CODE(text) Arguments of CODE Function: To use the CODE function we have to provide only one arguments: text : This is the only one argument which have to provide. In this we have to provide a text for which you want code. Example of CODE Function: Let’s learn about using this CODE function wit...

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...