Accountancy Part CSpreadsheet

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

Answer & explanation

Correct answer: option 4

The correct answer is Option (4) → TRIM

The TRIM function cleans an entry by removing the extra spaces before and after the text, so that data typed with stray spaces still matches. In data validation it is used to stop a user from entering spaces before or after the text.

NCERT (2026-27 edition):
Data Validation – “We can prevent user from adding … spaces before or after the text in entry. The TRIM function removes spaces before and after the text.”