Now it gets a bit funky.

In cell F1 we will now make the long SQL string to insert a line into the DB.

Type the following verbatim:

="INSERT INTO `verbORadj` VALUES ("

Hit enter and you should see:

INSERT INTO `verbORadj` VALUES (

I usually have to copy those backward `apostrophes` since I am on a Japanese keyboard and it causes problems. That is the first part of the static data. Most of the rest is dynamic.

From this point you just concatenate the cells together using & and “”. The “” go around strings (or things we just want to show) and the cells with values in them are just referred to by the letter and number of the cell. So the next part to add on to the above line is:

="INSERT INTO `verbORadj` VALUES ("&A1&",’"

Which will now show:

INSERT INTO `verbORadj` VALUES (1,’

Yes the apostrophe is dangling there on the end.

So we keep going. I HIGHLY suggest you do one segment at a time and check by hitting return. You either want to end with “ or a cell reference like B2. You can’t end with the ampersand since that means AND something. It would be like saying “I have been to Paris and.”    And what?

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

Will result in:

INSERT INTO `verbORadj` VALUES (1,’run

Now this was a little tricky and might be hard to see. After the value of cell A1, which is the number 1, we want a comma so we have to include that in the quotes. A1&”,”  The next value has an apostrophe so let’s add that into the quotes with the comma. Now it looks like &A1&",'". Ampersand quote comma apostrophe quote.

To keep going we add another & and continue with B1 ampersand quote apostrophe comma apostrophe.

="INSERT INTO `verbORadj` VALUES ("&A1&",'"&B1&”’,’”

And you get

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