TRIM

The TRIM function returns a string based on a given string, after removing extra spaces.

TRIM(source-string)

source-string: Any value from which to remove extra spaces.

Notes

  • TRIM removes all spaces before the first character, all spaces after the last character, and all duplicate spaces between characters, leaving only single spaces between words.

Example

=TRIM(" spaces spaces spaces ") returns "spaces spaces spaces" (the leading and trailing space were removed).

Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Naudingas?
Ženklų limitas: 250
Didžiausias ženklų limitas yra 250.
Dėkojame už atsiliepimą.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.