result = [box1.value, box2.value, box3.value].join(";");

The parameter of the join method is not limited to being a single character - you can use any string you want (e.g. " and "). If you don't specify a string, it defaults to a comma.

It needs to be a variety of things. Well, one ; and the rest :

 

Oh, and some nothing at all.

result = box1.value + ";" +
    [box2.value, box3.value, box4.value].join(":");

In the case of the Excel spreadsheet it looks like...

=(CONCATENATE(A11,";",B11,":",C11,":",D11,E11,F11,G11,":",H11,":",I11,":",J11,K11,":",L11,":",M11,":",N11,":",O11,":",P11,":",Q11,":",R11))

Well in that case just use something like

result = [
    box1.value, ";",
    box2.value, ":",
    box3.value, ":",
    box4.value,
    box5.value,
    // etc.
    box23.value
].join("");

You could probably imagine ways to make it more efficient/cleaner, e.g. join all the colon-separated bits first, then add them to the other ones.

Seems I was over complicating things. Whilst the code isn't pretty I didn't need to concatenate at all.

Glad I could help :C

I'm sorry. I meant to say thanks.

 

I'm so rude :-(

(hug)