Thursday, February 7, 2008

HW #3

1. Put the text Josh Horatio Waxman into cell A1. Use the MID function to extract the first letters of the first name, middle name and last name. Put them together again to form J. H. W.

2. In column A, put the letters A through Z, a through z, and the numbers 0 through 9. In column B, use the CODE function to find the corresponding ASCII code. In column C, use the CHAR function to covert the ASCII codes in column B back into symbols.

No comments: