Excel Tricks with Tejraj

In this blog post, we will learn to convert text in “Proper Case” in excel. What is Proper Case? Proper case is somewhat different than “lower case” and “upper case”. In lower case all the letters are in “lower case” whereas in upper case all the letters are in “upper case”. But in Proper Case, first word from each word is in “upper case” and all the other letters are in “lower case”. Converting Text in Proper Case: Now we will learn to convert the text into Proper Case with simple example. For this we prepared dummy data as shown in below image. In the first column we have inserted input text which we will convert into Proper Case in the next Column. For this we will use “PROPER” function which is readily available in excel. First of all select the cell in which we have to convert the input text in Proper Case. In this case we have selected cell “B2”. Now, type “=PROPER(A2)” in cell “B2”. Once we type above function in cell “B2”, we have to just hit enter button on our keyboard. This ...

One of my friend asked me to provide dynamic way of converting binary numbers in to hexadecimal numbers. Though there is already a function available in excel BIN2HEX() but my friend requested me to provide some customization in it. I tried my level best and provided him a solution. We will learn to create same format through this blog post. YouTube Video: Just follow below easy steps and create your own template to convert binary numbers into hexadecimal numbers. 1. Under Developer tab click on Insert command ( Click here if developer tab is not visible on your ribbon ). 2. Click on Toggle button from the available buttons. 3. Draw a shape and you will see “Toggle Button” get appear on your screen. 4. Click on this toggle button and you will see “Format” tab will appear on your Ribbon . Under this tab adjust the height and width as below: Height: 1cm Widht: 1.65 cm 5. Toggle button will now look as shown in below image. 6. Right Click on the resized Toggle Button and click on “Proper...