I cannot seem to find a way to do this. I have five cells in excel. I want to concatenate them into a string randomly. I want to use each cell character once in the string I am building, so I end up with a five-character string, no repeats. Say, I have A1 = Y, B1 = u, C1 = 6, D1 = %, E1 = z I want to build a string that has each character in a random order uY6%z or zY%u6 either are equally acceptable (et cetera)
Is there a way to do this?