TRIM
Returns a string where all whitespace characters (spaces, tabs, newlines, etc.) have been removed from both the start and end of the specified string.
Syntax
=TRIM(string)
Arguments
| Argument | Type | Description |
|---|---|---|
| string | String | The string to trim whitespace characters from |
Examples
=TRIM("ABC ")→"ABC"
Removes the trailing whitespace characters from the string
=TRIM(" DEF")→"DEF"
Removes the leading whitespace characters from the string
=TRIM(" GHI ")→"GHI"
Removes leading and trailing whitespace characters from the string
=TRIM("Hello World")→"Hello World"
As there are no whitespace characters at the beginning or end of the string, the string is returned unchanged.
Updated 10 months ago