You want to remove the unprintable characters and unnecessary spaces from column A. What formula would you put into cell B2 to copy down to the rest of the column?
- =ERROR.TYPE(A2)
- =CLEAN(TRIM(A2))
- =CHOOSE(A2)
- =TRIM(A2)
The correct answer is:
- =CLEAN(TRIM(A2))
🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers