Here is the formula for using MID: =MID, location of text, the starting number, the number of characters. Here is an example of how you would write the formula: =MID(B1,10,15).

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.