CLEAN EXCEL FORMULA
| EXCEL FORMULA | |||
| Function Dictionary | Function Examples | Function Categories | |
CLEAN |
|||||||||
| Dirty Text | Clean Text | ||||||||
| Hello | Hello | =CLEAN(C4) | |||||||
| He llo | Hello | =CLEAN(C5) | |||||||
| Hello | Hello | =CLEAN(C6) | |||||||
| What Does It Do? | |||||||||
| This function removes any nonprintable characters from text. | |||||||||
| These nonprinting characters are often found in data which has been imported | |||||||||
| from other systems such as database imports from mainframes. | |||||||||
| Syntax | |||||||||
| =CLEAN(TextToBeCleaned) | |||||||||
| Formatting | |||||||||
| No special formatting is needed. The result will show as normal text. | |||||||||