Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Text > CLEAN
 

CLEAN(text)

 
 Returns the text string will all the non printable characters removed.

 textThe text string you want cleaned.

 REMARKS
 
  		• This function removes any non printable characters include tabs and program specific codes.
     
  		• The "text" can consist of other worksheet functions (see Rows 1 & 2).
     
  		• This can be a useful function to use when you import data from another program.
     
  		• This function only removes the ASCII characters 1-31.

     EXAMPLES
     
     A
    1=CLEAN(CHAR(7)&"text"&CHAR(7)) = text
    2=CLEAN(" some text"&CHAR(7)&"some more ") = some textsome more
    3=CLEAN(20) = 20
    4=CLEAN(-1) = -1
    5=CLEAN(FALSE) = FALSE
    6=CLEAN(LEFT("hello ",7)) = hello
    7=CLEAN(CHAR(4000)) = #VALUE!
    		 
     Functions - C | Index - C | Text Manipulation | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top