TRIM

แƒกแƒขแƒ แƒ˜แƒฅแƒแƒœแƒ˜แƒ“แƒแƒœ แƒจแƒ•แƒšแƒ˜แƒก แƒฆแƒแƒ แƒ”แƒ‘แƒก, แƒกแƒ˜แƒขแƒงแƒ•แƒ”แƒ‘แƒก แƒจแƒแƒ แƒ˜แƒก แƒขแƒแƒ•แƒ”แƒ‘แƒก แƒ›แƒฎแƒแƒšแƒแƒ“ แƒ”แƒ แƒ— แƒฆแƒแƒ แƒ˜แƒก แƒกแƒ˜แƒ›แƒ‘แƒแƒšแƒแƒก.

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

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!