Trim spaces on every sheet
Remove extra spaces from A1:Z1000 on every sheet in the workbook.
Changes data. A backup copy and an undo point are turned on.
What it does, step by step
- Repeat on every sheet:
- Trim extra spaces in A1:Z1000
- End of repeat
Use it in MacroRoni: open the Starter gallery, search for "Trim spaces on every sheet", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More workbook tools macros
Workbook toolsTidy the whole workbookOn every sheet: fit the columns and freeze the top row. Then go to A1 everywhere.Doesn't change valuesWorkbook toolsBack up, then clean the dataSave a copy of the workbook first, then trim, remove hidden characters, empty rows and duplicates.Changes data · backup onWorkbook toolsRefresh data and saveRefresh every query and connection, then save the workbook.Doesn't change values