Excel Tricks with Tejraj

In this blog post we will learn about CONCATENATE function in excel. CONCATENATE function joins several text string into once text string. Where to find CONCATENATE function on Excel Screen: CONCATENATE 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. CONCATENATE function is highlighted in red in below image. Once we click on CONCATENATE option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of CONCATENATE Function: The Syntax of CONCATENATE function is as below: =CONCATENATE(text1, [text2],….) Arguments of CONCATENATE Function: To use the CONCATENATE function we have to use below arguments: text1 : This is mandatory argument in which we can provide 1st text string. text2 : This is optional argument in which we can provide 2nd text string. In similar way, we can provide maximum 255 text stings...

In this blog post we will learn about DOLLAR function in excel. DOLLAR function will convert number into text, using currency format. The currency symbol which we can see in the output will depends upon the local language settings. Where to find DOLLAR function on Excel Screen: DOLLAR 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. DOLLAR function is highlighted in red in below image. Once we click on DOLLAR option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of DOLLAR Function: The Syntax of DOLLAR function is as below: =DOLLAR(number, [decimals]) Arguments of DOLLAR Function: To use the DOLLAR function we have to use 02 arguments: number : In this, we can provide a number or we can select a cell which contains number or a formula which will return a number. decimals : This is optional ar...

In this blog post we will learn to calculate length of text string in excel. To calculate length of text string we will use “LEN” function in excel. Where to find LEN function on Excel Screen: LEN 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. “LEN” function is highlighted in red in below image. Once we click on LEN option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of LEN Function: The Syntax of LEN function is as below: =LEN(text) Arguments of LEN Function: To use the LEN function we have to use only one argument: Text : This is only one and mandatory argument. We have to select the text for which we have to calculate text length. Example of LEN Function: Let’s learn about using this function with the help of simple example. We have listed text strings in column B as shown in below ima...

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