Understanding Text Functions
Text functions in Excel are some of the most useful word-processing and data-management tools you’ll find anywhere—they perform tasks that word-processing programs can’t. These functions are conveniently listed for you when you click the Text button on the Formulas tab on the ribbon.
You can use the TRIM and CLEAN functions to remove extra spaces and nonprinting characters, which is great for cleaning up imported data—a task that ranges from difficult to impossible using search and replace. The UPPER, LOWER, and PROPER ...
Get Microsoft® Excel® 2010 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
