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?

  • =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

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock