Working with Names

Names are enormously useful in Excel. They make it easier to work with everything from worksheet ranges to arrays to constants to formulas and more.

There's no brief, crisp definition of the term name as it's used in Excel. It's best to look at examples of names to see how they're used and how they function. This book is concerned mainly with names as they apply to worksheet ranges, but keep in mind that names have a variety of uses.

Naming Formulas

Suppose that you frequently work with data that consists of a person's first name and last name: For example, you might have George Washington in cell A1 and John Adams in cell A2. You might want to strip off the person's first name, perhaps for use in a salutation. One way would ...

Get Managing Data with Microsoft® Excel now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.