Spreadsheet Tips

Remove Spaces with Text to Columns in Excel

February 19, 2019
An example remove extra spaces using Text to Columns.

"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:

  1. Select a range of data to trim
  2. Click Data > Text to Columns
  3. Choose "Fixed width"
  4. 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.