[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
TRIM ( string )
Description: Makes a string that is a copy of string with the leading and trailing space characters removed, and each sequence of embedded spaces reduced to a single space. The space character referred to here is character U+0020.
Arguments:
|
Name |
Type |
Description |
|
string |
Designates the string to be trimmed. |
Return Type and Value: text – The trimmed copy of string.
[Example:
TRIM(" abc def ") results in abc def
end example]