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.