The ways to easily remove numbers from the left in Excel are not unique to numbers. You can use this same formula to remove other characters from a string of values in Excel.

If you apply this formula to a number, it will remove leading and trailing spaces but limit the in-between spaces to 1. For removing all the spaces from numbers, you may use the next two methods.

You can use Excel's built-in substitute function to remove or replace a substring of a string of characters in Excel. This can include removing hyphens from Social Security numbers or any other ...

Open a new Microsoft Excel 2010 spreadsheet. Click on cell "A1," or whatever cell you want your random number to wind up. Enter the following formula into the cell, without quotes: "=INT (RAND ...

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.