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

Currently, the TRIMRANGE function and the trim references are available only in Microsoft Excel 365. If you would like to follow along in using this function, you can download this Excel workbook and ...

Alongside Excel's TRIMRANGE function and Trim Refs operators, there are other ways to clean up your data in Excel, such as using Power Query or making the most of AI through Copilot.

Want to delete or truncate numbers to the left in Excel? Learning how to remove numbers in Excel from the left is a neat trick to automate subtracting unwanted digits.