Removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular spacing.
Syntax
- Text Required. The text from which you want spaces removed.
| Data | Formula | Result | Description | |
| Kazam Raza | =TRIM(A2) | Kazam Raza | Removes leading and trailing spaces from the text | |
| =TRIM(” Kazam Raza “) | Kazam Raza | Removes leading and trailing spaces from the text |