Trim (text as String) as String
|Removes all spaces from a text string except for single spaces between words
|FormulaField And BusinessRules
|text as String
|Represents a text string or reference to a field that returns a value of type text
|Returned value as String
|Returns a text string value equal to the text specified in the "text" parameter with all spaces removed except for single spaces between words
Create a formula on a description field that will remove spaces from the start and end of a text string. For example, "this is a test " will return "this is a test".