Computer Science
NULL
Medium
Question
Which Excel function removes extra spaces from text, keeping single spaces between words?
A
TRIM
✓ Official correct answer
B
SUBSTITUTE
C
CLEAN
D
REPT
Community credibility
Registered members can vote for the answer they believe is correct today and explain why. If the facts change after an election or news event, suggest a new option so others can vote it up.
A
TRIM
No member explanations yet for this option.
B
SUBSTITUTE
No member explanations yet for this option.
C
CLEAN
No member explanations yet for this option.
D
REPT
No member explanations yet for this option.
Explanation
TRIM strips leading/trailing and repeated spaces.
Related Questions
Q
How many preset margin options can be set in MS Excel?
Medium
· Computer Science
Q
Which Excel feature lets you define names for use in formulas (other than Create...
Medium
· Computer Science
Q
How do you split text from one column into multiple columns in Excel?
Medium
· Computer Science
Q
Which of the following is a common language for Artificial Intelligence?
Medium
· Computer Science