Make Yes/No answers consistent
Turn y, Y, yes, true and similar answers in column D into exactly “Yes” or “No”.
Changes data. A backup copy and an undo point are turned on.
What it does, step by step
- Change y, yes, true to Yes in D2:D1000
- Change n, no, false to No in D2:D1000
Use it in MacroRoni: open the Starter gallery, search for "Make Yes/No answers consistent", 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