The TRIM function returns the text with the white space removed from the beginning and the end.
=TRIM(" This is a test. ")
would return "This is a test".
- text - Required. The text from which you want remove starting and ending white space.