TRIM
āĻ¸ā§āĻā§āĻ°āĻŋāĻ āĻĨā§āĻā§ āĻĢāĻžāĻāĻāĻž āĻ¸ā§āĻĨāĻžāĻ¨ āĻ¸āĻ°āĻŋāĻ¯āĻŧā§ āĻĢā§āĻ˛ā§, āĻļāĻŦā§āĻĻā§āĻ° āĻŽāĻ§ā§āĻ¯ā§ āĻļā§āĻ§ā§āĻŽāĻžāĻ¤ā§āĻ° āĻāĻ āĻ āĻā§āĻˇāĻ° āĻ¸āĻŽāĻžāĻ¨ āĻĢāĻžāĻāĻāĻž āĻ¸ā§āĻĨāĻžāĻ¨ āĻ°āĻžāĻā§āĨ¤
TRIM("Text")
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.
