To remove any nonprinting characters from a text string,use the ________ function.
A) CLEAN
B) PROPER
C) TRIM
D) SUBSTITUTE
Correct Answer:
Verified
Q25: To change the text string jaMEs sMITh
Q26: If cell A2 contains the string "Excel
Q27: All of the following statements are TRUE
Q28: When a primary key from one table
Q29: All of the following statements are TRUE
Q31: _ are functions that manipulate data to
Q32: You can import tables and queries from
Q33: To change the word apple with orange
Q34: To remove all spaces from text except
Q35: A social security number is commonly used
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents