excel training in telugu
When data files are imported or copied into Excel worksheet non-printable characters can sometimes be included along with the good data.
A common example of these non-printable characters is the small box shaped character seen in cell D1 in the image above.
The CLEAN function can be used to remove most of these non-printable characters.
ASCII Character Codes
Each character on a computer – printable and non-printable – has a number known as its ASCII code or value.
ASCII stands for the American Standard Code for Information Interchange and it encompasses one set of codes for 255 characters and symbols for use in computer programs.
The first 32 characters (0 to 31) of the ASCII set are referred to as control characters and they are used by programs to control peripheral devices such as printers.
As such, they are not intended for use in a worksheet and they cannot be printed. In addition, they also create errors in Excel formulas if they are present in a cell along with good data.
The CLEAN Function’s Syntax and Arguments
A function’s syntax refers to the layout of the function and includes the function’s name, brackets, and arguments.
The syntax for the CLEAN function is:
= CLEAN ( Text )
Text – (required) the data from which you want to remove non-printable characters. Although the argument can contain the actual data, it can also be a cell reference to the location of the data in the worksheet.