MacroRoni

Starter macros › Clean up

Tidy a messy list

Trim spaces, remove hidden characters, delete empty rows and duplicates, then fit the columns.

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

What it does, step by step

  1. Trim extra spaces in A1:Z1000
  2. Remove hidden characters in A1:Z1000
  3. Delete empty rows
  4. Remove duplicate rows (checks column 1)
  5. Auto-fit the columns

Use it in MacroRoni: open the Starter gallery, search for "Tidy a messy list", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.

Get MacroRoni free

More clean up macros

Clean upFix numbers stored as textTurn numbers typed as text back into real numbers so totals and sorting work.Changes data · backup onClean upStandardize namesTrim spaces and capitalize each word in a column of names.Changes data · backup onClean upFill the gapsWrite N/A into empty cells so missing values are easy to spot and count.Changes data · backup on