Excel Function : TRIM
Category
Text
Description
Removes spaces from text
Microsoft Excel Reference Page
https://support.office.com/en-us/article/TRIM-function-410388fa-c5df-49c6-b16c-9e5630b479f9
Syntax and Description of the TRIM Excel Function
The syntax for the TRIM function in Microsoft Excel is as follows: =TRIM(text) Where text is the text string that you want to trim.
About TRIM Excel Function
The TRIM function in Excel removes all spaces from a text string except for single spaces between words. For example, the text string " Hello World " would become "Hello World" after using the TRIM function.