Remove Spaces with Text to Columns in Excel
"Text to Columns" is great for splitting up data but that's not all it does. We can also use it to trim extra spaces off our data in bulk. Here's how:
- Select a range of data to trim
- Click Data > Text to Columns
- Choose "Fixed width"
- Click "Finish" to close the wizard.
Boom! 💥 Our data has been cleaned!
This technique is great when working with large datasets because it's often faster than using the TRIM function.