Hi All,

I am hoping you can help, I have two sets of 8 letters and I want to compute each possible combination by randomly selecting 4 letters from each set. The 1st set I have put in A1-A8 and the second set I have put in B1-B8 (though these could easily be moved if necessary). I want excel to return all possible combinations for the above, ideally with each resulting string of 8 letters returned to a single cell.

I am totally new to the idea of macros / code within excel and have managed to follow a couple of online tutorials to create a simple macro, but I don't have the understanding to convert this into useful knowledge to solve the above!

Any help much appreciated!

Many Thanks,
Kate