CLEAN(text)
- text is any string to remove non-printable characters.
Description
- It removes all non-printable characters from text entered.
- Printable characters are from ASCII values 32 to 127
- CLEAN function remove all other characters other that ASCII values 32 to 127..
Example
| CLEAN("�ZCubes�") | �ZCubes� | ZCubes |
|---|---|---|
| CLEAN(B5) | ஸtrial� | trial |
| CLEAN(nb) | 89 | Y |
| CLEAN("†††cross†††") | †††cross††† | cross |