Page 248 - Excel 2007 Bible

17_044039 ch12.qxp 11/21/06 11:05 AM Page 205
Creating Formulas That
Manipulate Text
xcel is, of course, best known for its ability to crunch numbers. It’s also
quite versatile, however, with handling text. As you know, you can enter IN THIS CHAPTER
Etext for such things as row and column headings, customer names and How Excel handles text entered
addresses, part numbers, and just about anything else. In addition (as you may into cells
expect), you can use formulas to manipulate the text contained in cells.
This chapter contains many examples of formulas that use a variety of functions Excel’s worksheet functions that
to manipulate text. Some of these formulas perform feats that you may not have handle text
thought possible.
Examples of advanced text
formulas
A Few Words About 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 any-
thing else. That “anything else” is considered text.
NOTE You may hear the term string used instead of text. You can use
NOTE
these terms interchangeably. Sometimes they even appear
together, as in text string.
How many characters in a cell?

A single cell can hold up to 32,000 characters. To put things into perspective,
this chapter contains about 31,690 characters. How do I know that? I copied the
entire chapter and pasted it into a single cell. Then I used the LEN function to
count the characters. I certainly don’t recommend putting that much text into a
cell. Performance is extremely sluggish, and it’s very likely that Excel will crash.

205