O'Reilly logo

2007 Microsoft® Office System Inside Out by Microsoft Corporation

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 word-processing programs can’t do. You’ll find them conveniently listed for you when you click the Text button on the Formulas tab on the Ribbon.

Understanding Text Functions

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 functions change the case of words, sentences, and paragraphs with no retyping. You might find yourself copying ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required