TRIM
Removes spaces from text.
TextBeginner EssentialsMost UsedText Cleaning
What it does
Removes extra spaces from text: trims leading/trailing spaces and reduces multiple spaces to one.
Syntax
TRIM(text)
Arguments
text(text) — Text to clean.
Examples
Remove extra spaces
Clean up spacing in A2.
FORMULA
=TRIM(A2)
RESULT
Ana Silva
SAMPLE DATA
| A | |
|---|---|
| 1 | Text |
| 2 | Ana Silva |
| 3 | Tom Lee |