MacroRoni

Starter macros › Workbook tools

Back up, then clean the data

Save a copy of the workbook first, then trim, remove hidden characters, empty rows and duplicates.

Changes data. A backup copy and an undo point are turned on.

What it does, step by step

  1. Save a copy named “Before cleanup”
  2. Trim extra spaces in A1:Z1000
  3. Remove hidden characters in A1:Z1000
  4. Delete empty rows
  5. Remove duplicate rows (checks column 1)

Use it in MacroRoni: open the Starter gallery, search for "Back up, then clean the data", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.

Get MacroRoni free

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 toolsRefresh data and saveRefresh every query and connection, then save the workbook.Doesn't change valuesWorkbook toolsComma format on every sheetShow the numbers in B2:Z1000 on every sheet as 1,234.Doesn't change values