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

Use the SUBSTITUTE () function to remove non-printable characters in Excel Excel offers a CODE () function which returns the ASCII code for a given character.

Finding and removing blank spaces and rows in Excel is easy and can be done by using the "Find & Select" feature. Here's how to delete blank rows in Excel on a Mac or PC.