Concept:The =TRIM() function is used to clean text by removing extra spaces, leaving only single spaces between words.
Explanation:It removes all leading and trailing spaces from a text string.
It also reduces multiple spaces between words to a single space.
For example, " Hello World " becomes "Hello World".
This is helpful when cleaning data copied from other sources that contain irregular spacing.
Note: =TRIM() does not remove non‑breaking spaces (character code 160). Use =SUBSTITUTE() for that.
Answer:Removes extra spaces from text except for single spaces between words (Option B).