Remove extra spaces from text
Strip leading, trailing and double spaces so imported text lines up cleanly.
The formula
=TRIM(A2)How it works
Before
␣␣Hello World␣␣
After
Hello World
TRIM removes spaces before, after, and extra spaces between words.
Strip leading, trailing and double spaces so imported text lines up cleanly.
=TRIM(A2)TRIM removes spaces before, after, and extra spaces between words.