Concat with using ' " ' as an argument so I can use the output as a string.

[gamebot]

I am trying to speed up some programming by letting excel do the work. Currently I have two columns with data which will require adding them in order to create a data structure map. C1 is the variable lookup, C2 is the value.

A1 = 1
B1 = 100

I'm currently using:
= CONCAT("val[?", A1, "] = ", B1, ";")

and getting:
val[?1] = 100;

However, since I need values to be strings I need it to look like this, with quotes around the answers.
val[? "1"] = "100";

I tried using a combination of single and double quotes within its own arguments, such as """, '", ""...so forth can't seem to get it to work. Sorry if this is noob question but couldn't seem to find an answer right off when looking also.

[JohnTopley]

In "old" format ...

="val[?"&"""" &A1&""""&"] = "&""""&B1&""";"

which I am sure you can "translate" into CONCAT format

[gamebot]

Worked like a real treat using &! Thank you. Ended up doing this:

Please Login or Register  to view this content.

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.