Function Reference: CLEAN
| Syntax | ||
| =CLEAN(text) | ||
| Purpose / Description | ||
| Returns a cleaned text string, from which non-printing characters have been removed. | ||
| Arguments | ||
| Name | Type | Description |
| text | text string | A constant, reference or nested expression that provides the text string from which the non-prinintg characters have been removed. |
| Return Values | ||
| Type | Specific Value | Description |
| text string | A text string which is the original text string passed to the text argument with the non-printing characters removed. | |
| error | Any errors referenced by arguments are returned due to propagation of error values. | |
| Notes / Comments / Advice / Warnings | ||
| Comment: | Does not remove some characters, which are not non-printing, but which users commonly wish removed - the characters 129 (used in Unicode files) and 160, the non-breaking space, very common in data sourced from the web. In these cases, use the SUBSTITUTE function to remove the 129 character and to replace the 160 character with a space. |
|
| Examples: | Open / download sample workbook: CLEAN.xlsx | |