CLEAN

CLEAN helps you perform data calculation and analysis in AirSheet worksheets. It provides the tools you need to enter the CLEAN function quickly, work with flexible parameters, and handle different calculation scenarios more efficiently. With CLEAN, you can write formulas by starting with =, enter CLEAN( to view automatic syntax guidance with parameter requirements and examples, use correct arguments, and return results directly in a cell. It also supports cross-worksheet references, nested calculations, and automatic recalculation when source data changes, with manual recalculation available if needed. Whether you're checking formula syntax, correcting parameter or bracket errors, reviewing function examples, or troubleshooting incorrect results caused by text-formatted numbers or circular references, CLEAN helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.

1:53