Want to delete or truncate numbers to the left in Excel? Learning how to remove numbers in Excel from the left is a neat trick to automate subtracting unwanted digits.

For example, in the photo above, Excel returns a #NUM error in cell B4 due to the number in cell A4, which is impossible to calculate. See photo above.

How to Remove Circular References in Excel. In a Microsoft Excel 2010 spreadsheet, you may have formulas sitting in one cell that require the information within another cell in order to calculate.

How to Remove Whitespace From a String in Excel. Rarely is formatting perfect when you copy data from external sources into Microsoft Excel. As an example, you might copy business data from an ...

Pro Tip: To open formatting options, just select the cell (s) you want to format and press Ctrl-1 (Mac: Command-1). This actually works for anything in Excel: charts elements, images, etc.