scrambling the numbers in excel

[compudevil]

Hello,

I want to scramble the cells containing the telephone numbers.
I used the scramble software but it scrambles the numbers including the numbers in one particular cell which make my telephone number look bad,..

Is there any other way where I can jumble all the telephone numbers!!!

Thanks in Advance,

 

[AnotherHiggins]

I don't get why you want to do this, but how about using a helper column with the function
=rand()
copy that formula down for all rows containing data, then sort on that new column.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[compudevil]

tO:ANOTHERHIGGINS!!!

Hey thanks man,....it worked. I m doing dat coz I dont wann ne1 know that numbers are dragged in series,...so i want to jumble all ups and downs,....If therz other way round where I can do the same than lemme know as well,...thanks mate
Appreciated,...


P PATEL