CLEAN
Removes all nonprintable characters from text.
Text Cleaning functions are for real-life data: exported reports, copied lists, and inconsistent user input. Clean text first, then analyze with confidence.
This collection groups Excel functions that are commonly used for text cleaning workflows. Instead of browsing hundreds of formulas, you can focus on the exact tools that solve this type of task.
Each function page includes a short explanation and practical usage context. Use these functions as standalone tools or combine them to build more advanced, maintainable formulas.
If you frequently work with reports, dashboards, or recurring templates, bookmarking the key functions from this collection will speed up your day-to-day work.
Removes all nonprintable characters from text.
Converts text to number in a locale-independent manner.
Replaces characters within text.
Repeats text a given number of times.
Substitutes new text for old text in a text string.
Formats a number and converts it to text.
Returns text that occurs after given character or string.
Returns text that occurs before a given character or string.
Combines the text from multiple ranges and/or strings.
Splits text strings by using column and row delimiters.
Removes spaces from text.
Converts a text argument to a number.