Excel Tricks with Tejraj

In this blog post we will learn about CHAR function in excel. With the help of CHAR function we can convert numbers from 1 to 255 into their respective character codes. Where to find CHAR function on Excel Screen: CHAR 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. CHAR function is highlighted in red in below image. Once we click on CHAR option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of CHAR Function: The Syntax of CHAR function is as below: =CHAR(number) Arguments of CHAR Function: To use the CHAR function we have to provide only one arguments: number : This is the only one argument which have to provide. In this we have to provide number between 1 to 255. Example of CHAR Function: Let’s learn about using this CHAR function with the help of simple example. We entered random numbers ...

In this blog post we will learn about REPT function in excel. With the help of REPT function we can repeat text string “n” number of times (where “n” is positive value to be provided by user). Where to find REPT function on Excel Screen: REPT 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. REPT function is highlighted in red in below image. Once we click on REPT option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of REPT Function: The Syntax of REPT function is as below: =REPT(text, number_times) Arguments of REPT Function: To use the REPT function we have to provide 02 arguments: text : This is mandatory argument in which we can provide text which we want to repeat. number_times : This is also mandatory argument in which we can provide positive number which specifies how many times we wan...

Many times we receive data in excel which is not properly formatted. It may contain some unwanted spaces which will waste our extra time to remove them. In this blog post we will learn to remove these unwanted spaces from text string in excel. For this we will use TRIM function which is readily available in excel. Where to find TRIM function on Excel Screen: TRIM 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. TRIM function is highlighted in red in below image. Once we click on TRIM option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of TRIM Function: The Syntax of TRIM function is as below: =TRIM(text) Arguments of TRIM Function: To use the TRIM function we have to use only one arguments: text : This is the only one and mandatory argument in which we can provide text string from which we ...