Go to the Home tab and in the Clipboard group select the Paste drop-down arrow then choose Paste Special. Insert a formula in a table cell. CharacterSUBSTITUTECell Character Assuming that you would like to add a hash sign before each word within a bunch of cells such as.
Please do as follows.
Once you have copied the code in the code window you can go back to your worksheet and use this function just like any other regular Excel function. The SUM function in Excel allows you to add up the values in a range of cells. Now we need to do the calculation to get the. For more shortcuts like this and for building strong muscle memory in Microsoft Excel you can play with keySkillset educational games that include more than 200 shortcuts and over 70 formulas.