Now either reverse them and type the new correct answer D11 and vice versa for F11, or I would just copy and paste the group of cells from above into the opposite side as shown below. To copy the cells just click and drag and then hit CTRL-C or go to Edit-Copy.



The bluish highlighted area is the part I just pasted.

 

Ok, now we are getting really close, but we need to convert this into the url encoded style that Flash can read. Now we are getting into some heavier Excel stuff, but bear with me, it’s not so bad.

 


Go back up to the top and click on cell H1.

 

Now we are going to concatenate all these things into one space-less string.

 

In cell H1 type the following verbatim with no spaces:

 

=A1&B1

 

Then hit return and you will see the first part of your string.

 

&word1=run

 

Now go back to H1 and double click to start retyping in the cell, or use the function bar at the top, and type the following (we are just adding this on to the end of A1&B1:

 

=&C1&D1&E1&F1

 

So it should completely look like this:

 

=A1&B1&C1&D1&E1&F1

 

When you hit return, you will see the whole line as a Flash readable URL string.

 

&word1=run&answer1=verb&wrong1=adj

 

Now comes my favorite part. Click cell H1 and then find the little magic box and drag it down to row 20.

BOOYA!! Excel just did everything for you.