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.

Microsoft Excel 365 has introduced two new tools: the `TRIMRANGE` function and the `Trim References` operator. These features are designed to address common challenges in data management by ...

So start by cleaning up the text in cell B1 by typing =TRIM(B1) into cell C1, for example. The result will be cleaned up text in cell C1. Repeat the function for any other cells you need tidied up.

Discover essential Excel functions to clean and organize messy data. Learn tips to streamline your workflow and save hours of manual edits.