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). |