Special Edition Using® Microsoft® Office Excel 2003

Chapter 15. Text Functions

In this chapter

• Text Functions Overview

• CONCATENATE

• EXACT

• FIND

• FIXED

• LEN

• LOWER

• MID

• PROPER

• RIGHT

• Add st, nd, rd, and th to the End of Numbers

• SUBSTITUTE

• TRIM

• UPPER

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 ...