SCRAMBLE

SCRAMBLE(sCellContents)
Returns the characters of a text string with all the characters in a random order.

sCellContentsThe number or text you want to scramble.

REMARKS
You can use the RANDOMNUMBER function to return a random number between two bounds.


EXAMPLES

 A
1=JS.SCRAMBLE("sometext") = ttesxoem
2=JS.SCRAMBLE("better solutions") = b erotnsteuislto
3=JS.SCRAMBLE("better solutions") = utlsesnotr eibot
4=JS.SCRAMBLE("123456") = 145623
5=JS.SCRAMBLE("123456") = 315642

MORE FUNCTIONS
REMOVENUMBERS Removes all numbers from a text string and removes all spaces at the beginning and end of the result.
REVERSE Returns the characters of a text string in reverse.


© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext