The CONCATENATE Function
Joins several text strings into one text string.
CONCATENATE(text1,text2,...)

Text1, text2, ... are 1 to 30 text items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references.The "&" operator can be used instead of CONCATENATE to join text items.

  1. Label cell W2 as "Earnings to Date"
  2. In cell W3, enter a formula that calculates the overall earnings in dollars for each of your companies (hint: you will use "F" and "U")
  3. Make a note of the company that has the highest amount of earnings so far.
  4. In cell A51 type: "Lesson 6"
  5. In cell A52 type: "CONCATENATE EXAMPLE"
  6. In cell A53 type: "is "
  7. In cell A54 type: "our "
  8. In cell A55 type: "best "
  9. In cell A56 type: "company."
  10. In cell A57 type: =CONCATENATE(A53,A54,A55,A56)
  11. Before cell A53 in the formula in cell A57, insert the cell name of the company that made you the most money overall (in terms of dollars, not percentage).
  12. Make sure to leave a blank space after each word (in A53 through A56) to separate the statement created in A57.
Hosted by www.Geocities.ws

1