TRIM

文字列の間に空白文字を 1 文字分だけ残し、文字列から空白を削除します。

TRIM("テキスト")

Text refers to text in which spaces are to be removed.

=TRIM(" hello world ") returns hello world without leading and trailing spaces and with single space between words.