At this point I just copy and paste and change the cell reference.




In the function bar select back to the & before the B1 and copy that. Then paste it at the end. Then change the 2nd B1 to C1. Do that again and change the last one to D1. We are almost done

 

Now the function looks like:

 

="INSERT INTO `verbORadj` VALUES ("&A1&","&"'"&B1&"','"&C1&"','"&D1&"'"

 

And shows:

 

INSERT INTO `verbORadj` VALUES (1,’run’,’verb’,’adj’

 

That last part is D1ampersand quote apostrophe quote.

 

Now the ending is simple. Just add this to the end:

 

&");"   The ) and ;  are in quotes because we simply want them to be shown.

 

The whole finished SQL line is now:

 

INSERT INTO `verbORadj` VALUES (1,’run’,’verb’,’adj’);

 

Now select F1, find the magic box and drag it down and once again Excel just saved you hours of typing. Once you get one correct then they are all correct. Now we get to paste this into the SQL query test box of phpMyAdmin.