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.

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 ...

The function should something look like this: "Left (A1,5)." Use the "Right" function to remove a specified number of characters from the right side of a text string.

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.