Clear N/A placeholders
Find every “N/A” typed into the sheet and remove it, leaving the cell empty.
Changes data. A backup copy and an undo point are turned on.
What it does, step by step
- Replace “N/A” with nothing
Use it in MacroRoni: open the Starter gallery, search for "Clear N/A placeholders", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More clean up macros
Clean upTidy a messy listTrim spaces, remove hidden characters, delete empty rows and duplicates, then fit the columns.Changes data · backup onClean 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 on