Chapter 15. Text Functions

Text Functions Overview

Text functions can be used in several ways. They can return the number of characters in text strings, remove extra spaces and nonprintable characters from cells, return exact data within a string, change the case of text strings, and even combine text from other cells. If you inherit workbooks from other people, you will eventually have to clean up or manipulate the data. Text functions allow you to create consistency throughout the workbook. Because certain functions are case sensitive, it’s good practice to create consistency throughout lists and ...

Get Special Edition Using® Microsoft® Office Excel 2003 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.