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
B) SUBSTITUTE
C) CLEAN
D) REPT

Trim is correct answer, it is used to remove all spaces from a text string except for single spaces between words.