CLEAN

The CLEAN function in Google Sheets is a useful tool to remove non-printable ASCII characters from a given text. Whether you're working with data imported from external sources or dealing with special characters, the CLEAN function simplifies the task. Learn how to use it effectively with our comprehensive guide.

Function Syntax and Parameters

Syntax: CLEAN(text)

Parameters:

• text: The text value or cell reference containing the text to clean.

Step-by-Step Tutorial

1. Cleaning a text value:
   • Example: =CLEAN("Hello!␣World")
   • Result: "Hello! World"

Use Cases and Scenarios

1. Data Cleaning: Remove non-printable characters from imported data.
2. Text Processing: Normalize text by eliminating special characters.
3. Data Validation: Ensure text inputs do not contain non-printable characters.

Related Articles

• Top 4 Basic Text Functions Every Google Sheets User Should Know
• 10 Essential Google Sheets Formulas Every User Should Know