Posts

Showing posts from February, 2013

How to add text to the beginning or end of all cells in Excel?

Image
 How to add text to the beginning or end of all cells in Excel? Sometimes you may need to add same specific text to the beginning or end of all cells in a selection. If you added the text to each cell manually one by one, it must be time-consuming. Are there easier ways? Yes, there are many easy tricks to add same text to the beginning or end of all cells in a selection. Suppose you have a name roll as following screenshot shows, and the follow methods will guide you add specified text at the beginning and end of each cell in A1:C5. There are two formulas to add specified text to the beginning or end of all selected cells in Microsoft Excel.  Method 1: & formula Enter the  ="Class A: "&A1  in Cell E1, and copy this formula to other cells with dragging the bottom right corner of the Cell E1. Method 2: Concatenate formula Enter the  =Concatenate ("Class A: ", A1)  in Cell E1, and copy this formula to other cells with with dragging

Steps to include Indian Rupee Symbol Font in MS Word and Excel

Image
Steps to include Indian Rupee Symbol in MS Word and Excel Download the file .  Rupee Font Version 3.0 Extract the files. (You will need winrar or 7zip installed in your PC to extract the files) Double click on the Rupee_Font_Installer.exe Click on "Install" button Done. :)       Go to setting ----- > Control panel ------> Regional & Lang Option ------> Customize ------> then click Currency tab Put currency symbol as " ` " click ok Open Excel Go to format cell (Ctrl + 1 command) Click to Number tab ------- > select currency as " ` " & ok it. Select fonts as Rupee_Foradian.ttf open a excel sheet get into--->insert then click (symbol) as given in above image Then select the font ( Rupee Foradian ) then click the Indian Rupees Symbol then insert it like above... Select font as Rupee Foradian and click the button above the tab ( ` ) when you selecting ur font as Rupee Foradian then only you can wr