CHAPTER 11
Using Formulas to Manipulate Text

---

IN THIS CHAPTER

• Seeing how Excel handles text entered into cells
• Exploring Excel worksheet functions that handle text
• Getting examples of advanced text formulas

---

Oftentimes, the work you do with Excel not only involves calculating numbers but also includes transforming and shaping data to fit your data models. Many of these activities include manipulating text strings. This chapter will highlight some of the common text transformation exercises an Excel analyst performs and in the process give you a sense of some of the text-based functions that Excel has to offer.

Working with Text

When you enter data into a cell, Excel immediately goes to work and determines whether you're entering a formula, a number (including a date or time), or anything else. That “anything else” is considered text.

---

NOTE

You may hear the term string used instead of text. You can use these terms interchangeably. Sometimes they even appear...