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

Click on the Replace All button in the Find and Replace dialogue box to apply the new color to the text. Excel will alert you with the number of replacements made in the entire sheet or the ...