Coding Spreadsheets
Add Dropdown Lists and Input Checks to a Sheet
Several people fill in the same spreadsheet in [SPREADSHEET_APP] and they keep typing things differently. The columns I want to control are: [COLUMNS_TO_CONTROL]. The all…
Coding · Spreadsheets
Tidy names, dates, phone numbers and duplicates in your sheet using easy formulas and built-in tools.
I have a messy list in [SPREADSHEET_APP]. Here are a few example rows, with personal details replaced by fake ones: [SAMPLE_ROWS]. The problems I see are: [PROBLEMS]. Please show me how to clean this up. For each problem, give me either a formula to put in a new helper column or the menu steps for a built-in tool (such as removing duplicates or splitting text into columns). Explain where to click and what each step does in plain words. Remind me to make a copy of the sheet first so I can go back if something goes wrong. Finally, tell me how to turn the cleaned formulas into plain values so I can delete the old columns safely.
Tip: Replace real names, emails and phone numbers with made-up ones before pasting your sample rows.