About This Document
The Gnumeric Manual, version 1.8
- Welcome!
- How to Use this Manual
- A Quick Introduction
- Gnumeric Elements
- Working with Data
- Advanced Analysis
- Graphics: Plots, Images, Widgets, and Drawings
- Configuring Gnumeric
- Working with Files
- Printing
- Getting More Help
- Reporting a Problem
- Extending Gnumeric
- Function Reference
  - Bitwise Operations
  - Complex
  - Database
  - Date/Time
  - Engineering
  - Erlang
  - Finance
  - Gnumeric
  - Information
  - Logic
  - Lookup
  - Mathematics
  - Number Theory
  - Random Numbers
  - Statistics
  - String
    
    ASC
    
    CHAR
    
    CLEAN
    
    CODE
    
    CONCATENATE
    
    DOLLAR
    
    EXACT
    
    FIND
    
    FIXED
    
    LEFT
    
    LEN
    
    LENB
    
    LOWER
    
    MID
    
    PROPER
    
    REPLACE
    
    REPT
    
    RIGHT
    
    SEARCH
    
    SUBSTITUTE
    
    T
    
    TEXT
    
    TRIM
    
    UNICHAR
    
    UNICODE
    
    UPPER
    
    VALUE
  - Time Series Analysis
- Keybinding Reference

CLEAN

The Gnumeric Manual, version 1.8
Function Reference
String

CLEAN —

Synopsis
Description
Examples
See also

Synopsis

CLEAN(string)

Description

CLEAN removes any non-printable characters from string.

This function is Excel compatible.

Examples

CLEAN("one"\&char(7)) equals "one".

See also