Okay, I know this is really really simple, but for the life of me, my brother and I cannot get this to work properly.

  • We have a number in Cell D4(and down).
  • In E5 is the binary conversion of D4.
  • In F2-N2 we want to have the individual numbers of the binary sequence.

ie: In D4 is 258. So F2 should display 1. G2-L2 should display 0. M2 should have 1 and N2 should have 0

I need the functions that go in F2-N2. Can someone please help me. I've been torturing myself over it for the last 3 hours and I know it's really simple.

8 Years
Discussion Span
Last Post by mistercow.pnoy

The easiest option is to use the MID and COLUMN functions. I've attached a spreadsheet which shows how this is done, and explains it too.

Oh man, that's perfect. It's the idea that I had to do it, I just didn't know how to implement it.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.