
6
Working with Text,
Dates, and Times
O
ur focus so far has been on processing numerical data. We
have looked at functions whose arguments are numbers
or logical values. In many applications, we need to work
with arguments or data that consist of strings of characters, text
paragraphs, or special sequences of numbers representing dates
and times. In this chapter we will look at Excel functions that deal
with such arguments, and will illustrate the use of such functions
through examples.
Text in Excel
You may recall that Excel recognizes three types of entries in cells: numbers includ-
ing dates and times, formulas, and text. Through ...