Random shuffle cell values?

[Ed]

I have single-digit numbers in A1 thru E1. Is there a formula that will let
me take these values and randomly shuffle them to make a 5-digit number?

Ed

 

[Biff]

Hi!

One way:

Enter this formula in A2 and copy across to E2:

=RAND()

To make the 5 digit number enter this formula in some cell:

=(A1&B1&C1&D1&E1)*1

Now, to randomize the digits:

Select the range A1:E2

Goto Data>Sort

Sort by ROW 2

Click the Options button

Sort Left to right

OK,OK

To select a new 5 digit number just repeat the sort.

Biff