Business Solutions Formulas and Functions with Microsoft® Office Excel 2007

Chapter 7. Working with Text Functions

IN THIS CHAPTER

• Excel’s Text Functions 143

• Working with Characters and Codes 145

• Converting Text 149

• Formatting Text 150

• Manipulating Text 152

• Removing Unwanted Characters from a String 152

• Extracting a Substring 155

• Generating Account Numbers 158

• Searching for Substrings 158

• Substituting One Substring for Another 162

In Excel, text is any collection of alphanumeric characters that isn’t a numeric value, a date or time value, or a formula. Words, names, and labels are all obviously text values, but so are cell values preceded by an apostrophe (‘) or formatted as Text. Text values are also called strings, and I’ll use both terms interchangeably in this chapter.

In Chapter 3, “Building Basic Formulas,” you ...