The TRIM function removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular spacing.| support.microsoft.com
