CLEAN

CLEAN helps you process and calculate data in spreadsheets. It provides the tools you need to enter the function correctly, review its syntax and parameters, and troubleshoot common errors, making your work more efficient and helping you accomplish tasks with ease. With CLEAN, you can insert the function through the function dialog, type =CLEAN(...) directly in a cell or formula bar, view syntax help while entering the formula, and open detailed function help for parameter guidance. Whether you're checking a #VALUE! error, comparing results that do not match expectations, or applying the same formula across multiple cells with fill or copy and paste, 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.