Which function is used to remove spaces

CUET Preparation Today

Start Free Mocks

Home Questions S6EZSUVF95

Target Exam

CUET

Subject

-- Accountancy Part C

Chapter

Spreadsheet

Question:

Which function is used to remove spaces before and after the text?

Options:

DUPLICATE

REMOVE

DELETE

TRIM

Correct Answer:

TRIM

Explanation:

The correct answer is option 4- TRIM

TRIM function is used to remove spaces before and after the text.

We can prevent user from adding spaces before or after the text in an entry. The TRIM function removes spaces before and after the text.