You can remove leading, trailing, and extra spaces between characters and numbers in Excel using TRIM(), SUBSTITUTE() or Find and Replace.

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

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.