शनिवार, 18 जून 2022

Learn How to use Clean Excel formula for data cleaning excel

CLEAN

clean data in excel

What Does It Do?This function removes any non-printable 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.

कोई टिप्पणी नहीं:

एक टिप्पणी भेजें