Excel for Marketing Managers

Secret Code Maker

Secret
Code Maker

After you type in your message in the grid above, the coded message will appear

below. Copy and paste the coded message and give to your friends electronically

in an email or text file. Or, you can hand copy the numbers on a piece of paper.

11. You will use the Excel function CODE to change the letters from the top
    grid into numbers in the bottom grid. Because an empty cell will result in
    an error message, you will use an IF statement to tell Excel what to do
    when that happens.

a. Start by clicking on cell B19. While holding down the Shift key, use the

Right and Down arrow keys to highlight the range of cells B19:P25. Any

formula that you type will start to appear in cell B19.

b. Type in the following formula: =IF(B7=””,””,CODE(B7))

However, instead of just pressing Enter when you have finished, press

Ctrl+Enter to put a similar formula into all the cells.

12. Shift sheet location to the end and delete extra sheets.
    Move your cursor to the Sheet tabs at the bottom of the page and right click
    on the tab for this worksheet (it’s probably named Sheet1) Click on Move or
    Copy. Now click on (move to end) and the box next to Create a Copy. Click
    OK. The new worksheet will be named Sheet1(2). Right-click on any other
    tabs at the bottom of your sheet and select Delete.

Note:

Notice that there are no spaces in the formula. After the second equal sign, there

are two sets of two quotation marks separated by a comma. Typing four apostro-

phes will not work. Type some words into the top grid to make sure the worksheet

works.