TRIM

Removes spaces from a string, leaving only a single space character between words.

แƒกแƒ˜แƒœแƒขแƒแƒฅแƒกแƒ˜

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.

Please support us!

Please support us!