Concatination of a list.

[CIHBrankin]

Hi All,

I have a list of 20 three digit codes. I need to produce a macro to combine each one of these codes with two more three digit codes (these can be 3 of the same code) to end with a 9 digit string. The issue is I need to make a list of all the possible outcomes which is 8000 in total (20x20x20)

Hopefully some on e can help out.

Kind Regards

Chris

[ragulduy]

Please Login or Register  to view this content.