Excel 2010 Bible

Chapter 11: Creating Formulas That Manipulate Text 239 Cross-Reference See Chapter 24 for more information about custom number f ...

Part II: Working with Formulas and Functions 240 These functions are quite straightforward. The formula that follows, for exampl ...

Chapter 11: Creating Formulas That Manipulate Text 241 The following formula returns the last 10 characters from cell A1; if A1 ...

Part II: Working with Formulas and Functions 242 The following formula uses the REPLACE function to replace one character beginn ...

Chapter 11: Creating Formulas That Manipulate Text 243 For example, assume that cell A1 contains the text Annual Profit Figures. ...

Part II: Working with Formulas and Functions 244 For example, if cell A1 contains the text Blonde On Blonde and B1 contains the ...

Chapter 11: Creating Formulas That Manipulate Text 245 =RIGHT(A1,LEN(A1)-FIND(“*”,SUBSTITUTE(A1,” “,”*”,LEN(A1)- LEN(SUBSTITUTE( ...

Part II: Working with Formulas and Functions 246 The formulas that follow all assume that the name appears in cell A1. You can e ...

Chapter 11: Creating Formulas That Manipulate Text 247 Removing titles from names .............................................. ...

Part II: Working with Formulas and Functions 248 The formula is rather complex because it must determine whether the number will ...

249 CHAPTER Working with Dates and Times IN THIS CHAPTER An overview of using dates and times in Excel Excel date-related functi ...

Part II: Working with Formulas and Functions 250 A serial number of 1 corresponds to January 1, 1900; a serial number of 2 corre ...

Chapter 12: Working with Dates and Times 251 For example, if you need to enter June 18, 2010 into a cell, you can enter the date ...

Part II: Working with Formulas and Functions 252 As you can see in Table 12.1, Excel is rather flexible when it comes to recogni ...

Chapter 12: Working with Dates and Times 253 In Excel, the smallest unit of time is one one-thousandth of a second. The time ser ...

Part II: Working with Formulas and Functions 254 Because the preceding samples don’t have a specific day associated with them, E ...

Chapter 12: Working with Dates and Times 255 FIGURE 12.1 Use the Number tab in the Format Cells dialog box to change the appeara ...

Part II: Working with Formulas and Functions 256 Why does this bug still exist in later versions of Excel? Microsoft asserts tha ...

Chapter 12: Working with Dates and Times 257 Inconsistent date entries ......................................................... ...

Part II: Working with Formulas and Functions 258 Date-Related Worksheet Functions .............................................. ...