Taking the above example, we may remove extra spaces between characters and numbers in Excel using the SUBSTITUTE() function as follows: Place your cursor on cell C5 and type the following function: ...