Reminders on Material Covered Monday Oct 29

1. The CONCATENATE Function combines text strings
2. All text strings MUST be in quotation marks
3. In the concatenate function, use a comma between all elements that are to be combined. For example If the first element is the contents of B2 followed by a text string containing a comma and a space followed by the contents of cell A2 your formula would look like this:
CONCATENATE(B2,", ",A2)
Look carefully at this function. You see three commas. The comma afetr B2 means that more elements follow. The comma after the quotaion is part of the text string. It will appear as a comma followed by a space in your data. Then the second quotation mark ends the text string. It is followed by a comma which means another element follows. That element is A2 which represents the contents of cell A2.

4. Use the Shift Click technique to select a range of cells.

5. Use Control-D to fill a range of cells DOWN.

6. KNOW what a field, a record, a range, and a cell are.