easyFPSCNTSCSSPPSCMS Office & Productivity
Answer explanation
Explanation included
Practice quiz ready
Question

In MS Excel, which of the following functions can be used to remove all spaces from a text string except for single spaces between words?

ATRIM
BSUBSTITUTE
CCLEAN
DREPT

Choose an option to check yourself, or reveal the answer and explanation instantly.

Related MS Office & Productivity MCQs

View all

Test Yourself

Take a full quiz on MS Office & Productivity

Start Quiz

Exam Coverage

FPSCNTSCSSPPSC

Trust

Answer is visible after reveal
Explanation helps learning
Free topic quiz available

Subject

MS Office & Productivity

Save your progress

Create a free account to bookmark MCQs and track weak areas.

Register Free
Start QuizMore MCQs
Answer and explanation

Correct Answer: A: TRIM

Explanation: The correct answer is A: TRIM. The TRIM function removes all spaces from text except for single spaces between words, cleaning irregular spacing from imported data. SUBSTITUTE removes all spaces including those between words, while CLEAN removes non-printable characters.

In MS Excel, which of the following functions can be used to remove...