Quiz › Data Cleaning

Data Cleaning Quiz

Extra spaces, duplicates and splitting names. Choose a topic. Each topic has 5 questions.

Clean up text

A1 has the name Ravi with 2 spaces before it and 2 after it. What will this formula return? =LEN(TRIM(A1))