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...? Mcqs

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