CLEAN

CLEAN text with any non-printable characters removed

Synopsis

CLEAN(text)

Arguments

text: string

Description

CLEAN removes non-printable characters from its argument leaving only regular characters and white-space.

Microsoft Excel Compatibility

This function is Excel compatible.