Computer Science
Medium
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?
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.
Related Questions
Q
The maximum margins can be set in MS Excel are ____________?
Medium
· Computer Science
Q
Which function allows to define names/text in formulas except the use of selecti...
Medium
· Computer Science
Q
How to split a single columns’ text into multiple columns?
Medium
· Computer Science
Q
Which of the following is the common language for Artificial Intelligence?
Medium
· Computer Science