[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
CLEAN ( string )
Description:
Makes a string that is a copy of string with all so-called "non-printable" characters—those with internal values in the range U+0000–001F—removed.
Arguments:
|
Name |
Type |
Description |
|
string |
Designate the string to be cleaned. |
Return Type and Value: text – The trimmed copy of string.
[Example:
CLEAN("A" & CHAR(2) & "BC") results in ABC, which is stored in A10
LEN(A10) results in 3
end example]