Removes nonprinting characters (character codes 1 – 29) and special Word characters from the specified string or changes them to spaces (character code 32), as described in the "Remarks" section. Returns the result as a string.
Syntax
expression.CleanString(String)
expression Optional. An expression that returns an Application object.
String Required String. The source string.
Remarks
The following characters are converted as described in this table.
Character code | Description |
---|---|
7 (beep) | Removed unless preceded by character 13 (paragraph), then converted to character 9 (tab). |
10 (line feed) | Converted to character 13 (paragraph) unless preceded by character 13, then removed. |
13 (paragraph) | Unchanged. |
31 (optional hyphen) | Removed. |
160 (nonbreaking space) | Converted to character 32 (space). |
172 (optional hyphen) | Removed. |
176 (nonbreaking space) | Converted to character 32 (space). |
182 (paragraph mark) | Removed. |
183 (bullet) | Converted to character 32 (space). |