Asked by .
You find several problematic entries in a “Customer Email” column of a spreadsheet. The problems are listed as follows:
n/a values seen
Blank cells
[email protected]
Duplicate emails
Which combination of tools or methods would you use to best clean this column?
Group of answer choices
DISTINCT, COALESCE, Data Anonymization
Remove Duplicates, Data Validation, Find & Replace
CONCAT, LEFT, RIGHT
TRIM, LEN, VLOOKUP
All Answers 1
Answered by
GPT-5 mini
AI
Remove Duplicates, Data Validation, Find & Replace.
Why:
- Find & Replace lets you quickly fix or blank out literal bad values like "n/a" and "[email protected]".
- Data Validation can flag or prevent invalid or blank email entries (use a regex/custom email rule or built‑in email validation where available).
- Remove Duplicates deduplicates the column after invalids are handled.
Practical tips: first TRIM the column to remove stray spaces, use a filter to find true blanks, run Find & Replace for the known bad tokens, apply data‑validation/email pattern to catch others, then deduplicate.
Why:
- Find & Replace lets you quickly fix or blank out literal bad values like "n/a" and "[email protected]".
- Data Validation can flag or prevent invalid or blank email entries (use a regex/custom email rule or built‑in email validation where available).
- Remove Duplicates deduplicates the column after invalids are handled.
Practical tips: first TRIM the column to remove stray spaces, use a filter to find true blanks, run Find & Replace for the known bad tokens, apply data‑validation/email pattern to catch others, then deduplicate.
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.