How to Use Special Characters in Excel Formulas


There are five special characters that are commonly used in Microsoft Excel 2007 workbooks. The special characters all serve different functions to make sure that Excel correctly understands your formula. Keep reading to learn what these special characters are and how to use them in your Excel formulas.

Things You'll Need

  • Microsoft Excel 2007
  • Start Microsoft Excel 2007 and open an existing workbook that has multiple worksheets or start a new blank workbook.

  • Click in the cell where you would like to insert a formula that contains a special character.

  • Type an exclamation point (!) between the name of a worksheet and the cell reference to refer to a cell reference in just one particular worksheet within a workbook.

  • Use an apostrophe (') in front of and behind the name of a file name or worksheet name when the name contains a space. This will tell Excel to look for the entire name of the file or worksheet.

  • Insert brackets ([]) into the formula to place them around a file name to ensure that Excel recognizes it as a file name.

  • Enter a colon (:) when you want to use a range within the formula. A colon can be read as the word "through." For instance, a cell range can be typed as A13:C16. It is read A13 through C16.

  • Utilize a plus sign (+) when you want to use a range in a formula. A plus sign can be read as the word "and." You could insert the cell range B13+B55, which can be read B13 and B55. Press the "Enter" key when you are finished inserting the special character. The result of the formula will be displayed within the cell.

Promoted By Zergnet


You May Also Like

Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!