RE: [OT] Binary bits in excel

Shifting right by 4 places is effectively dividing by 16.

So:

INT(A1/16) where A1 is the worksheet reference of the original number should do the trick.

Cheers

Mike