Video Review of HW $ 4

Some clarification about the homework.
In this Excel homework, we record our first Excel macro. We also use CHAR and CODE to make a character uppercase, and use IF with those two built-in-functions to make the lowercase work even for characters which are already lowercase. We explain what was intended by the portion of the assignment about entering in REPT formulas.

Video Review of HW#3

Part 1:
In which we use the MID function in Excel to extract certain substrings, and then concatenate them together using the ampersand operator.


Part 2:
We play a bit with the CODE and CHAR function, and the LOWER function for good measure. All this to get a firmer sense of how characters, the building blocks of strings, work.