Skip to Content
Excel 2003: The Missing Manual
book

Excel 2003: The Missing Manual

by Matthew MacDonald
December 2004
Beginner
791 pages
26h 21m
English
O'Reilly Media, Inc.
Content preview from Excel 2003: The Missing Manual

Chapter 10. Manipulating Dates, Times, and Text

Most of the functions this book has looked at so far focus on crunching raw numbers. Excel also provides functions that work with other types of data, however, including dates, times, and ordinary text. For example, although there’s no way to “add” one piece of text to another, you might want to pull first and last names from different columns and join them together in a single column. Or, you might want to remove a word that appears in a bunch of column titles. Similarly, you might want to replace a character in a word, capitalize a name, or count the number of letters in a cell. Excel provides specialized functions for all these tasks, and you’ll learn about them in this chapter.

Dates and times also have their own specialized functions. These functions perform some indispensable tasks, like retrieving the current time and determining what day of the week a given date falls on. In addition, Excel lets you perform calculations with dates and times just as you would with ordinary numbers. This chapter introduces these techniques, and explains how Excel stores dates and times behind the scenes.

Manipulating Text

You can’t use arithmetic operators like + and - with text. If you try to perform a calculation by referring to one or more cells containing text, Excel displays a #VALUE error message. However, there’s one operator that you can use: the concatenation operator (&), which joins together text. For example, imagine you have an individual’s ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Excel 2010: The Missing Manual

Excel 2010: The Missing Manual

Matthew MacDonald

Publisher Resources

ISBN: 0596006640Errata Page