BUY TELUGU TUTORIAL DVD'S:::: SEO::3500/-,DCA(DOS,WINDOWS,WORD,EXCEL,POWER POINT, MS ACCESS, INTERNET CONCEPTS)::499/-,DTP(PHOTOSHOP,PAGEMAKER, CORELDRAW,TELUGU TYPING)::999/-,C::700,C++::900,TALLY ERP 9:: 999,ORACLE:999/-,CORE JAVA::1000/-,SPOKEN HINDI:500,HTML::500/-,AUTOCAD::2500/-,DCA+DTP::1000/-,DCA+TALLY::1000,C,C++,JAVA::1500, ALL COURSES(DCA,DTP,C,C++,JAVA,ORACLE,TALLY,HTML,SPOKEN HINDI,AUTOCAD):: 3500/-..CONTACT : SYED HAFIZ, SHOPPING COMPLEX,8INCLINE COLONY,GODAVARI KHANI,KARIMNAGAR, TELANGANA,CELL:9395306603,EMAIL:COOLHAFI7@GMAIL.COM.
Home / Ms Office / Ms Excel 2007 / Excel training in telugu Clean Formula

Excel training in telugu Clean Formula

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.

About Hafiz

Check Also

Microsoft excel 2013 for beginners in telugu

Microsoft excel 2013 for beginners in telugu Part 1

Microsoft excel 2013 for beginners in telugu In this Microsoft excel 2013 for beginners in …

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.

STATE BANK OF HYDERABAD, ***NAME:Hafiz SD, BRANCH:JALLARAM, ACCOUNT.NO:62041435239, IFSC CODE:SBHY0020609,****, ANDRA BANK*** NAME:SYED HAFEEZ BABA, BRANCH:8INCLINE COLONY, ACCOUNT.NO:116710100037533****SBI****NAME:SYED HAFEEZ BABA,ACCOUNT NO:35321924009,IFSC CODE:SBIN0013338,BRANCH:GODAVARIKHANI.,...