View Single Post
  #4   Report Post  
Bernd Plumhoff
 
Posts: n/a
Default

Put your word (integer) into cell A1, select cells B1:B28 and enter
=MOD(INT($A$1/(2^(ROW()-1))),2)
with CTRL+SHIFT+ENTER (as array formula).

This will work for 28 bits (highest possible number: 268,435,455).

HTH,
Bernd