Excel 2002 Formulas phần 3

. Một tài liệu tham khảo Thông tư xảy ra khi một công thức đề cập đến giá trị riêng của mình, hoặc trực tiếp hoặc gián tiếp. Ví dụ, nếu bạn nhập vào ô, điều này tạo ra một tài liệu tham khảo Thông tư bởi vì các công thức trong ô A3 đề cập đến ô A3. | Chapter 5 Manipulating Text 137 REVERSETEXT Returns the text in a cell backwards. For example using Evian as the argument returns naivE. ACRONYM Returns the first letter of each word in its argument. For example using Power Utility Pak as the argument returns PUP. SPELLDOLLARS Returns a number spelled out in text as on a check. For example using as the argument returns One hundred twenty-three and 45 100 dollars. SCRAMBLE Returns the contents of its argument randomized. For example using Microsoft as the argument may return oficMorts or some other random permutation. ISLIKE Returns TRUE if a string matches a pattern composed of text and wildcard characters. CELLHASTEXT Returns TRUE if the cell argument contains text or a value formatted as Text. This function overcomes the problems described at the beginning of this chapter see Determining Whether a Cell Contains Text . EXTRACTELEMENT Extracts an element from a string based on a specified separator character such as a hyphen . Summary This chapter provided some background on how Excel deals with text entered into cells. It also presented many useful examples that incorporate Excel s text functions. The next chapter presents formulas that enable you to calculate dates times and other time-period values. Chapter 6 Working with Dates and Times IN THIS CHAPTER An overview of using dates and times in Excel Excel s date-related functions Excel s time-related functions Beginners often find that working with dates and times in Excel can be frustrating. To eliminate this frustration you ll need a good understanding of how Excel handles time-based information. This chapter provides the information you need to create powerful formulas that manipulate dates and times. The dates in this chapter correspond to the United States English date format month day year. For example the date 3 1 1952 refers to March 1 1952 not January 3 1952. I realize that this is very illogical but that s the way we Americans have been trained.