Chapter 9: Manipulating Data with VBA

---

Overview

When you're given a workbook filled with data, you're going to want to ask questions about the data. What is the sum of the sales for a day? Or a month? Or a year? How much time elapsed between a customer's orders? And is the data you're about to write to a text file in the proper format to be read into a database? You can answer all of these questions, and many more, using the text, number, and date/time processing functions available to you in Excel VBA.

In this chapter, you will learn how to do the following:

• Prepare text strings for processing.

• Concatenate, find, and modify strings.

• Perform summary calculations on numerical data.

• Make financial decisions using Excel calculations.

• Work with dates and times in Excel.

---