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

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.

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 ...

The Draw tab is not on Excel's ribbon by default. Learn how to enable, add and use the Draw tab and the various drawing tools in Excel.