Random binary string generation?

[Bebbspoke]

Hi Peoples; -

I require to generate a col string of random 0's or 1's - (no blank cells)
effectively just a simple random binary data string.
The appliance of weighting is not required...

I would have thought this would be available as a simple Excel function but cannot locare it...?

Thank you, Bebbspoke.

 

[Nine Zero]

try this maybe

=DEC2BIN((RAND()*100))

 

[mikerickson]

Try =--(RAND()>.5)

 

[Bebbspoke]

Hy Folks, thanks for your efforts; -

Nine Zero - your soln procures binary coded rand no. 0><100 in binary format - sry I didn't may my req. really clear...

Mike - perfect, thank you.

Cheers, Bebbspoke