This function trims to a single space any sequence of two or more consecutive spaces within a string. It also removes any leading or trailing spaces from the string.
string is the string in which you want to trim consecutive spaces greater than one space. string can be a constant, a character field, an expression that results in a string or a function that returns a string.
This function returns a string.
Calculated field example
If a Contact field contained " John Smith ", the following calculated field expression would return "John Smith": InTrim(Contact)
Records with the value "John Smith" can be selected or found with the expression: Intrim(Contact)="John Smith"