• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 14. Everyday Functions > Understanding Text Functions

Understanding Text Functions

Text functions in Excel are some of the most useful word-processing and data-management tools you'll find anywhere—they do things that word-processing programs can't do. For example, 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 text from other documents into Excel, just so you can apply these functions. Then choose Edit, Paste Special to convert the formulas to their resulting (text) values and return the text to the original document.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint